September 5, 2005 at 11:18 am
Hello
I am trying to replicate a database that includes two tables with an identity column. In order to get the transactional replication working, I have to edit the stored procedures sp_MSupd_table1 and sp_MSupd_table2 so that they don't try to set a value for the identity column during an update.
The only way I can think of to do this is to tell the snapshot agent to run a script to create the procedures after the snapshot has been taken. Because I have to create two stored procedures, I need two scripts. How do I configure it to run more than one?
Thanks
John
September 6, 2005 at 4:24 am
You should be able to package both scripts up in the post snapshot command.
you can also deploy them through sp_addscriptexec
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
September 6, 2005 at 4:30 am
Hilary - thanks. I think sp_addscriptexec would do it. I've actually now created the SPs I want in the subscriber database and configured them not to be overwritten during the snapshot process.
John
Viewing 3 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