none
Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object...

    Question

  • Hi all I set up transactional replication between a sql 2008 and sql 2005 server.  I have a table with an identiy column and a varchar field. I accidentally SET IDENTITY INSERT ON at the subscriber instead of the subscriber server and inserted a row. After that every row I inserted in the publisher has not be replicated to subscriber? I see this error message in the replication monitor?

    Violation of PRIMARY KEY constraint 'PK__IdentTes__32149A135070F446'. Cannot insert duplicate key in object 'dbo.IdentTest'

     

    I tried deleting the row at subscriber but still the same message?

    Thanks

    Wednesday, May 18, 2011 3:15 PM

Answers

All replies