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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply