How will Change All Identity Columns to NOT FOR REPLICATION

• rajesh.vr

  SSC Veteran

  Points: 278

  More actions

  July 23, 2009 at 5:12 am

  #203083

  Hi

  how will i change the Identity columns to NOTFORREPLICATION Option. Iam using Sql Server 2000. I want to configure the replicaion and the tables contains thousands of records. I do not want to loose any data from these tables

  Regards

  Rajesh V R

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  July 29, 2009 at 5:51 am

  #1031564

  Hmmm...not pretty

  You are going to have to generate a process that, for each table,

  generates a new table with the same schema which includes the NOT FOR REPLICATION, insert the records into the new table using IDENTITY INSERT.

  delete the existing table,

  rename the new table to the old name

  Hope this helps

  Regards

  Graeme