开发者

Transaction replication and Primary key Violation

开发者 https://www.devze.com 2023-03-12 18:51 出处:网络
SQL Server 2000 SP2 8.00.760 Error: Violation of PRIMARY KEY constraint \'PK__@snapshot_seqnos__3B9B84A9\'.

SQL Server 2000 SP2 8.00.760

Error:

Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__3B9B84A9'. Cannot insert duplicate key in object '#3AA76070'

.

I am getting this error in Dist. agent. I can't drop replication. What is the easiest way to figure out what is causing this and how can I avoid it. I even tried Dist. Agent Prof开发者_开发技巧ile name "Continue on data consistency errors."

0

精彩评论

暂无评论...
验证码 换一张
取 消