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?
View Complete Post