Violation of PRIMARY KEY constraint ‘PK_Constraint_1′. Cannot insert duplicate key in object ‘dbo.table1 error on Transactional Replication

This query will give you exact query which his creating PK violation here “xact_seqno” can be obtained from replication monitor. Run this on the distribution server as follows:

Query:

USE distribution
GO
EXEC sp_browsereplcmds
@xact_seqno_start = ’0x00001C3D00000B9A002800000000′,
@xact_seqno_end = ’0x00001C3D00000B9A002800000000′
GO

Leave a comment