I've broken my SQL Server 2K - Please help

HI,
Having spent some time playing around with replication across the net, I
decided to start from scratch with some hints and tips on other sites BUT I
started to remove the replication in the wrong order and it now wont allow me
to disable replication.
The message I get is;
error 3724 cannot drop procedure dbo.sp_selxxxx because its being used for
replication
Any ideas?
Thanks
Pls try using sp_removedbreplication to get rid of any remaining system
objects.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hi Paul,
I put that SP into the Analyzer and the same message still appears!
What now!
Thanks
TIM
"Paul Ibison" wrote:

> Pls try using sp_removedbreplication to get rid of any remaining system
> objects.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||Hi Paul,
Dont worry, have sorted it now.
Thanks for that.
TIM
Also just one other question.....
When I set up the distibutor/publisher on the main server I then setup a
subscriber PUSH to my other server. Do I need to setup a PULL/PUSH on the
subscriber as well or just that one well alone.
Thanks
""confused"" wrote:
[vbcol=seagreen]
> Hi Paul,
> I put that SP into the Analyzer and the same message still appears!
> What now!
> Thanks
> TIM
> "Paul Ibison" wrote:
|||Did you get the same message when running the proc or after running it and
when trying to delete the proc? Presumably the proc is in the same database?
Anyway, please try dropping them from Query analyser directly:
drop procedure dbo.[sp_sel_EE1F8F95DC214CA5ED44BBA96EA645E7_pal]
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

It's Urgent Please Help....

Hi, I've created one mailing label report with
2 Across Than 3 down.But it displays the data
like
1 4
2 5
3 6
Is there a way to change the default orientation from Down then Across
to Across and then down like this ?
1 2
3 4
5 6
Thanks & Regards
MalkeshOne idea ist to add a counter to your view and select only the datarows with
1, 3 ,5 ,7 ,9 ... and out them into ´1st column.
Then insert a subreport next to 1st column as col 2 and use the 2, 4, 6 ,8
... data rows from view.
Markus Pöhler
netpoint-edv gmbh
Germany
"Malkesh" wrote:
> Hi, I've created one mailing label report with
> 2 Across Than 3 down.But it displays the data
> like
> 1 4
> 2 5
> 3 6
> Is there a way to change the default orientation from Down then Across
> to Across and then down like this ?
> 1 2
> 3 4
> 5 6
>
>
> Thanks & Regards
> Malkesh|||Thanks,
But I'm Sorry, i need to explain the actual problem rather
giving you the layout.
Actually we have Event Badge Report with Badge Info is on Top
Left side and Receipt Info is On Top right side fro the event, and after that
as many tickets as individual is registered for shouls be print from next row.
So i need to layout the report Across tha Down.
How can i achieve this task ?
--
Thanks & Regards
Malkesh
"MarkusPoehler" wrote:
> One idea ist to add a counter to your view and select only the datarows with
> 1, 3 ,5 ,7 ,9 ... and out them into ´1st column.
> Then insert a subreport next to 1st column as col 2 and use the 2, 4, 6 ,8
> ... data rows from view.
>
> Markus Pöhler
> netpoint-edv gmbh
> Germany
>
> "Malkesh" wrote:
> > Hi, I've created one mailing label report with
> > 2 Across Than 3 down.But it displays the data
> > like
> > 1 4
> > 2 5
> > 3 6
> >
> > Is there a way to change the default orientation from Down then Across
> > to Across and then down like this ?
> >
> > 1 2
> > 3 4
> > 5 6
> >
> >
> >
> >
> > Thanks & Regards
> > Malkesh|||If you are doing this with a table. there is a property called writing-mode
lr-tb or tb-lr...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Malkesh" <Malkesh@.discussions.microsoft.com> wrote in message
news:8CFA0F60-3BF8-47D2-894E-58B370C6D9C4@.microsoft.com...
> Thanks,
> But I'm Sorry, i need to explain the actual problem rather
> giving you the layout.
> Actually we have Event Badge Report with Badge Info is on Top
> Left side and Receipt Info is On Top right side fro the event, and after
> that
> as many tickets as individual is registered for shouls be print from next
> row.
> So i need to layout the report Across tha Down.
> How can i achieve this task ?
> --
> Thanks & Regards
> Malkesh
>
> "MarkusPoehler" wrote:
>> One idea ist to add a counter to your view and select only the datarows
>> with
>> 1, 3 ,5 ,7 ,9 ... and out them into ´1st column.
>> Then insert a subreport next to 1st column as col 2 and use the 2, 4, 6
>> ,8
>> ... data rows from view.
>>
>> Markus Pöhler
>> netpoint-edv gmbh
>> Germany
>>
>> "Malkesh" wrote:
>> > Hi, I've created one mailing label report with
>> > 2 Across Than 3 down.But it displays the data
>> > like
>> > 1 4
>> > 2 5
>> > 3 6
>> >
>> > Is there a way to change the default orientation from Down then Across
>> > to Across and then down like this ?
>> >
>> > 1 2
>> > 3 4
>> > 5 6
>> >
>> >
>> >
>> >
>> > Thanks & Regards
>> > Malkesh

Issue Loading Data from Flat File

I have come across a strange bug that I can't get to the bottom of.

I have a source Excel spreadsheet with approx 30000 rows in it, I have saved this out using Excel 2003 as a csv file which contains all of the source rows.

Using a Flat File Source I am only getting approx 15000 rows through, I have re-saved the spreadsheet as csv and it stops at exactly the same point. However, if I use the excel spreadsheet as the source I get all 30000 rows.

I have checked the CSV at the relevant point and can see no reason why it would stop at that particular point.

I am experiencing a similar problem with another source file handled in exactly the same way.

Has anyone else experienced this?

Philip

UPDATE: looks like this could be a problem in Excel, Used a Excel Data source and a Flat File Destination to create the CSV, and my original Data flow now uses all the data

Philip Coupar wrote:

I have come across a strange bug that I can't get to the bottom of.

I have a source Excel spreadsheet with approx 30000 rows in it, I have saved this out using Excel 2003 as a csv file which contains all of the source rows.

Using a Flat File Source I am only getting approx 15000 rows through, I have re-saved the spreadsheet as csv and it stops at exactly the same point. However, if I use the excel spreadsheet as the source I get all 30000 rows.

I have checked the CSV at the relevant point and can see no reason why it would stop at that particular point.

I am experiencing a similar problem with another source file handled in exactly the same way.

Has anyone else experienced this?

Philip

UPDATE: looks like this could be a problem in Excel, Used a Excel Data source and a Flat File Destination to create the CSV, and my original Data flow now uses all the data

I'm working with Philip on this. Basically it looks as though there's problem in the way that Excel saves stuff to csv. Anyone know why?

-Jamie

|||

We are experiencing the same exact problem. The CSV file imports fine using our old DTS Packages just not with the new SSIS packages we have created. I can provide sample csv files if needed.

If you have an update on this, please let me know.

|||Did you see the workaround that Philip posted (above)?

-Jamie