Identity column in replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Identity column in replication

Hi, It is a requirement of our application that it requires the identity column enabled for its starting.
We are trying to go for a DR solution for the same. But the problem arises when we try to test the bringing up of the replica site. It gives database error beacuse while replicating, the identity field becomes "No". On the primary site it is kept as "Yes(not for replication)" I want that on the sec site also, the identity field be "Yes(not for replication)" Please suggest me a solution. Regards
Riya (kindly post the threads in relevant forum section only, moved from Analysis forum) Raulie
Also Using NOT FOR REPLICATION – Book Online. Regards. Arindam Ganguly
Thanks guys, My problem is solved using sp4…by making some changes in the replication script
Regards Riya