Tran Replication returns error 2627

• jerry6484

  SSC Enthusiast

  Points: 120

  More actions

  August 29, 2003 at 1:58 pm

  #76045

  I am having problems pushing a subscribtion when specifying - No, the subscriber already has the schema and data. Each time I try this I get the following error Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__484E27E5'. Cannot insert duplicate key in object '#475A03AC'.

  (Source: MMSSQLQ1 (Data source); Error number: 2627).

  If I subscribe and intialize the schema and data, there is no problem.

  I apply changes to the publishing db and subscribing db and update the replication sp's also before sunscribing.

  Is there a setting I am missing?

  Any help would be great.

  Thanks.

• September 1, 2003 at 8:00 am

  This was removed by the editor as SPAM

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 2, 2003 at 10:40 am

  #472219

  Not that I know of. It looks like you're out of sync somehow. Trying turning on the verbose logging for the distribution agent so you can some more details.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter