PK violation error during replication

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Park (anonymous_at_discussions.microsoft.com)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 04:42:25 -0700

While replicating some tables into another sql server for
DB sync., I run into a problem as follows;

===========================================================
Violation of PRIMARY KEY
constraint 'PK__@snapshot_seqnos__66DE2538'. Cannot insert
duplicate key in object '#65EA00FF'.

Violation of PRIMARY KEY
constraint 'PK__@snapshot_seqnos__66DE2538'. Cannot insert
duplicate key in object '#65EA00FF'.
(Source: TUBE\TUBE2 (Data source); Error number: 2627)
===========================================================

At MSDN, I found it's a kind of sql server bug.
(See, http://support.microsoft.com/default.aspx?scid=kb;en-
us;813494)

Unfortunately, to solve it, contact to Microsoft was
required and it cost some money & time to get the hot fix
from MS headquarter.-Currently, I'm in Asia.

So, I'd like to ask you guys to e-mail
(lovelydovey@msn.com) me the hot fix, if you have. Or, if
there's another way to solve this problem, pls, tell me
the rope..!

e-mail : lovelydovey@msn.com

Your answer would be appreciated!

Relevant Pages

  • Re: violation of unique constraint in distribution database
    ... What is the exact error message you are getting? ... "Violation of PRIMARY KEY ... duplicate key in object '#2E0AB83D'." ... we are getting violation of unique constraint in distribution database. ...
    (microsoft.public.sqlserver.replication)
  • replication fail
    ... When doing a search for "Violation of Primary Key ... >Violation of primary key constraint 'PK-measure'. ...
    (microsoft.public.sqlserver.replication)
  • Violation of primary key
    ... Violation of PRIMARY KEY constraint 'PK_CUSTOM2'. ... duplicate key in object 'MHGROUP.Custom2' ...
    (comp.databases.ms-sqlserver)
  • Violation of PK PK__@snapshot_seqnos__
    ... This is the full message "Violation of PRIMARY KEY ... constraint 'PK__@snapshot_seqnos__2D03DC75'. ... duplicate key in object '#2C0FB83C'." ... I was told that there is a patch for it. ...
    (microsoft.public.sqlserver.replication)
  • SP3 Rollup
    ... use it to fix when you get 'Violation of PRIMARY KEY ... constraint 'PK__@snapshot_seqnos__57C360A6'. ... duplicate key in object '#56CF3C6D'., ... Thank you Microsoft! ...
    (microsoft.public.sqlserver.replication)