March 11, 2012 at 9:35 pm
I am getting error on Transactional replication in sql server 2005, once Publisher server goes down, after that user insert the data into subscriber server through application, while the time got below error.
Msg 2627, Level 14, State 1, Line 3
Violation of PRIMARY KEY constraint 'PK_SafetyStock'. Cannot insert duplicate key in object 'dbo.SafetyStock'.
The statement has been terminated.
I have one doubt why identity key values not increment to subscriber server. ?
How to fix it?
Thanks
Jerry
March 13, 2012 at 8:54 am
You're right to be concerned about the identity column values. Please see the following for info...
http://www.replicationanswers.com/DR_Using_TR_in_SQL2005.asp
March 13, 2012 at 10:24 am
Identities are managed on each server. If someone adds a row to the subscriber, they can use an integer that the publisher expects to have available. If you have identities on both, you need to set ranges.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply