Do a select @@version and post back the results.

It could very well be this http://support.microsoft.com/kb/300383

I think the error happens when the distribution agent applies the snapshot at the subscriber.

Did you try what the error message says to do?  Execute the BCP command manually to get the error results in a file called "errorfile". 

I'd try that and see...

Arthur,

Take a look here:

open abc;

fetch abc into @xfinal;

close abc;

Why are you using a cursor to fetch one row from a select query? 

Select fldProduct,[1],[2],[3],[4],[5]

where fldOffset = 0

UNION ALL

Select fldProduct,NULL,[1],[2],[3],[4]

where fldOffset = 1

UNION ALL

Select fldProduct,[2],[3],[4],[5],NULL

where fldOffset = -1

and so on

jg

P.S. you should not store data this way.

El Barto,

If you are having "unable to allocate contiguous memory of XXXXX" type messages in your SQL error log, this is an indication of the MemToLeave type of memory error. ...

El barto,

How do you know you are leaking memory?  Is there a specific message that receive?

jg

Hi, check the publisher identity range at the distributor.  I had to manually update those to get a larger range.  distribution.dbo.MSrepl_identity_range.  I tried using the "Change Merge Article" sproc,...

I think that you could write a wrapper that would do that. The properties and methods of the DTS Package object are exposed, so it shouldn't be very difficult.

It would be...

I think this definitively answers the age-old Ninjas vs Pirates debate.

Thanks, and congratulations to all the winners!

jg

They both fail to run in zero seconds, but I use a binary collation.  Slackers!

I would expect, however, that the difference would be on the order of .001% of the total execution time,...

Hi Colin,

Socratic Irony FTW! 

So, it would seem, there are many ways around using cursors and what I described earlier is an example of a ridiculous workaround.  The cursor or...

Colin,

50 step job, one for each database.

You need to create the snapshot for the publication.  In the replication monitor on the distributor, open the Agents collection and look for the snapshot agent.  You should be able...

Wow.  Just wow.

Nice job Andy.  If you've helped one person, it was worth the effort.

jg