How do I resolve this SQL error
[-1] SQL Error: '[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_cat_validation'. Cannot insert duplicate key in object 'dbo.cat_validation'.' SQLState='23000' SQLNativeError=2627.
Software/Hardware used:
SQL Server 2005
Software/Hardware used:
SQL Server 2005
ASKED:
Feb 3, 2012 11:52 AM GMT
UPDATED:
February 28, 2012 8:32:18 AM GMT
RELATED QUESTIONS
- Complex SQL file join
- SQL Server 2008 Export data problem
- Connecting to a remote DB on a UNIX server with SQL
- Finding the public key in an asymmetric encryption on SQL Server
- Validate Windows XP Home edition
- Duplicate record
- Display system messages in window
- Errors: Violation of UNIQUE KEY constraint 'UN_FILENAME'. Cannot insert duplicate key in object
- Domino Server Insufficaint memory anc cannot boot the server
- ORACLE DBMS vs. SQL sever DBMS
Answer Wiki:
The error message is pretty explanatory.
You have a table with a primary key, and you are trying to insert a new record that matches the primary key of an existing record in the table.
To solve it, review your data and/or your application and do not try to insert duplicate records.
You have a table with a primary key, and you are trying to insert a new record that matches the primary key of an existing record in the table.
To solve it, review your data and/or your application and do not try to insert duplicate records.
60,255 pts.
To see other answers submitted to the Answer Wiki View Answer History.
