setting identity not for replication property help needed

• John Campbell-96530

  SSC-Addicted

  Points: 488

  More actions

  July 2, 2004 at 8:09 am

  #161873

  I am sure that this is a common problem but I can't find an aswer anywhere so here goes.

  I am going to do replication by restoring a backup of my production database on the replication server.

  When I do this there are about 50 tables that have an identity column set in the production database.  In order to avoid the "identity insert" error with these tables on the replication server I need to change the identity columns to "identity not for replication" so the replicated transactions can be updated in the replication database.

  So, what is the santax to change the idx field in table.info from identity to identity not for replication?

  alter table info ?????

  I have looked at the script that is generated with a change of a diagram doing this change but the script creates another database and copies the data.  This is not a practical solution for me because of the size of some of the tables, it would be quicker to just create the snapshot normally.

  Thanks,

  John Campbell

   

   

   

• July 5, 2004 at 8:00 am

  This was removed by the editor as SPAM

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  July 5, 2004 at 9:47 pm

  #513375

  I do not think that you can make this change to an existing column.   You will need to re-create the table with NOT FOR REPLICATION set.