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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy