View Complete Post
i am unable to insert values into my table when i am using primary key and foreign key in my tables i am sure that i have not voilated the constraints rules and its working well when i remove the constraints.....
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?