Violation of PRIMARY KEY constraint

[dangerman2k]

Hi. We're having a major prob this morning. We're getting the following message on a number of different databases when trying to insert records:

Violation of PRIMARY KEY constraint 'PK__Results__res_id__23494814': Attempt to insert duplicate key in object 'Results'.
dbErrNo = 80040E14
dbNativeErr = 2627
dbSqlState = 23000
Clearing Errors, Rolling back and closing connection

Clearly SQL (6.5) is having a problem when adding rows to the table but the Primary Key contraint is constraining the Identity field which I'm not specifying in the INSERT statement.

Any ideas?
Thanks in advance
Dan

 

[dbtech]

U can try this DBCC CHECKIDENT
check BOL for syntax

dbtech

 

[dangerman2k]

thanks, seems to fix the problem.
Any idea what causes this? it's happened on a lot of tables today!

Dan

 

[tlbroadbent]

Check the SQL FAQ for some explanation of SQL 6.5 identity problems.

http://www.swynk.com/faq/sql/sqlfaq_troubleshooting.asp#Identity

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin