Violation of PRIMARY KEY constraint Cannot insert duplicate key in object 
Author Message
 Violation of PRIMARY KEY constraint Cannot insert duplicate key in object
Heres the situation:

I am getting this error on multiple tables throughout my SQL2000
database.

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

I have checked the table CallIssue no duplicates. This same error
happens on many other tables as well.

I have checked for duplicate keys and I dont have any, however,
throughout the day I have been getting this error. Any ideas would be
great thanks..

-Mike



Tue, 08 Mar 2005 01:17:05 GMT
 Violation of PRIMARY KEY constraint Cannot insert duplicate key in object

You don't have any duplicate keys because the primary key constraint won't
let you.  Whenever you get that error message, it means an insert or update
statement ** did not get processed ** because it would have violated the
primary key constraint.

What you need to do is figure out which insert/update statement is
generating this error message, and correct the underlying issue.

--
Toby Herring
Software Architects, Inc.
MCDBA, MCSD


Quote:
> Heres the situation:

> I am getting this error on multiple tables throughout my SQL2000
> database.

> Violation of PRIMARY KEY constraint 'PK_CallIssue'. Cannot insert
> duplicate key in object 'CallIssue'.

> I have checked the table CallIssue no duplicates. This same error
> happens on many other tables as well.

> I have checked for duplicate keys and I dont have any, however,
> throughout the day I have been getting this error. Any ideas would be
> great thanks..



Tue, 08 Mar 2005 01:29:53 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Cannot Insert duplicate row in Primary Key violation

2. On Insert with IDENTITY, I get Msg 2627 Violation of PRIMARY KEY constraint

3. Server: Msg 2627, Level 14, State 1 Violation of PRIMARY KEY constraint 'PK_FACULTY'. Cannot insert duplicate key

4. Error 3009 Cannot insert duplicate key in object sysbackuphistory

5. Cannot insert duplicate key row in object

6. Violation of PRIMARY KEY constraint

7. ODBC Violation of Primary Key Constraint Can't Update Reord

8. Distribution Agent: Violation of PRIMARY KEY constraint error

9. 23000: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint

10. Violation of PRIMARY KEY constraint

11. Violation of PRIMARY KEY constraint ??


 
Powered by phpBB® Forum Software