I have a Pull Transactional Replication in SQL 2000.
To enable the copying of Identity columns, my subscriber Insert stored procs are modified to mark
SET IDENTITY_INSERT TableName ON
In the end, I set it to Off.
The environment is stable for 2 years. Now we are upgrading to SQL 2008.
Do I still need to do the above step?
I have noticed that SQL 20088 is even updating Subscriber table for schema changes also.
I am not sure if MS took care of that issue in SQL 2008.
Please let me know your inputs.
View Complete Post