SQL Error 2627

• Ed7

  SSCrazy Eights

  Points: 8516

  More actions

  February 11, 2008 at 8:13 am

  #203463

  Dear All,

  I setup push transactional replication from production database to a datacenter (hostsite).

  The publisher and local distributor are running sql 2000 sp3.

  The subscriber is running sql 2005 sp2.

  When initial snapshoot completed with no error, I got an error with Violation of PRIMARY KEY constraint 'aaaaat_EnergyDataDaily_PK'. Cannot insert duplicate key in object 'dbo.t_EnergyDataDaily'. (Source: MSSQLServer, Error number : 2627).

  How and waht is the workaround to solve this errors.?

  Thanks.

• Vivien Xing

  SSChampion

  Points: 12297

  More actions

  February 19, 2008 at 11:20 pm

  #780089

  Have you figured out yet? Hope this may help.

  http://technet.microsoft.com/en-us/library/ms151757.aspx