Running scripts after snapshot replication

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  September 5, 2005 at 11:18 am

  #165376

  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

• Hilary Cotter

  SSCommitted

  Points: 1861

  More actions

  September 6, 2005 at 4:24 am

  #587712

  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

  http://www.indexserverfaq.com

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  September 6, 2005 at 4:30 am

  #587715

  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