.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

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

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
 
How this error could arise? I use data flow to insert rows from another server. I checked there is no duplicate key in primary key. thanks


View Complete Post


More Related Resource Links

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

  

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.....



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

  

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


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend