Primary Key Conflict Transactional Replication

• seven.srikanth

  Ten Centuries

  Points: 1212

  More actions

  December 14, 2011 at 7:16 pm

  #264862

  Hi All,

  Please someone provide me the TSQL commands to find the command which is causing the Primary Key Violation error using Transaction Sequence Number.

  Thanks.

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  December 20, 2011 at 6:16 am

  #1423594

  I'll give you the two tables and the proc to get them out.

  All the information you need is in the two tables. I've got a script that does this for me.

  Distribution.dbo.MSrepl_errors

  Distribution.dbo.MSrepl_commands

  EXEC sp_browsereplcmds @xact_seqno_start=@SeqNo, @xact_seqno_end=@SeqNo, @publisher_database_id =@publisher_db_id, @command_id=@cmdID