Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 VIOLATION OF PRIMARY KEY CONSTRAINT

Author  Topic 

Limuh
Yak Posting Veteran

94 Posts

Posted - 2008-02-15 : 01:23:12
Violation of PRIMARY KEY constraint 'PK_tbl_others. Cannot insert duplicate key in object 'tbl_others.
The statement has been terminated.-- What does it mean i cant load the data to tbl_others

sunil
Constraint Violating Yak Guru

282 Posts

Posted - 2008-02-15 : 01:50:51
This error is caused when you are trying to insert duplicate values into your table. Primary key column cannot have duplicate values. Check if primary key values you are trying to insert from source table already exist in table in which you want to insert.
Go to Top of Page

Limuh
Yak Posting Veteran

94 Posts

Posted - 2008-02-15 : 02:20:10
Thanks!
Go to Top of Page
   

- Advertisement -