Cannot insert duplicate key in object 'dbo.user'.rnthe statement has been terminated. ask question. up vote 12 down vote favorite. 5. update data return cannot insert duplicate key row in object. 4. entity framework insert object with related object. 231.. Of course you will not find a duplicate key (128503) in the database because of the primary key. hint: create a temp table with the same structure as the one you're inserting in and without. I am getting the following error when running an integration services project to insert and update data from one sql server database to another sql server database.
Violation of primary key constraint in update statement i am trying to update a table and i keep getting the "violation of primary key constraint 'pk_tbladdress_list'. cannot insert duplicate key in object 'tbladdress_list'.. I am expecting first row to be inserted (if not exist) and second row will update count of that row. but, it throws, violation of primary key constraint ''. cannot insert duplicate key in object '' previously calling this merge statement for one row at a time, and i was getting result as expected.. Cannot insert duplicate key row in object' dbo.test' with unique index 'test0'. if i do something like the below how would i get the rate_uno to update?? insert into cannot insert.