December 3, 2001 at 6:02 am
I am using transactional replication. When I create the publication article, I select to keep the existing table unchanged. However, when the snapshot is first applied, a bcp file is created with all the table's data in it. It sems my only option is to not run the snapshot at all, but I want to run it to automatically create the stored procs at the subscriber: any ideas?
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
December 3, 2001 at 3:49 pm
One would be snapshot it to another db, then script out what you need. In SQL2K it's easier, use sp_scriptpublicationcustomprocs.
Andy
December 4, 2001 at 3:56 am
See where you're coming from - thanks.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
October 21, 2005 at 1:29 pm
I remember having some stored proc error when I was playing around with trans replication. Then, I had gotten a missing sp error(don't remember which) but the way to solve it is to use sp_scriptpublicationcustomprocs, is it? How actually do you use this? Thank you. -Tejas.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply