SQL Server - Identity Fields *RESOLVED*

A new problem has emerged on a live SQL server database in that a table (that currently has about 22,000 rows) has suddenly developed problems.

Whenever we attempt to insert a new record, it comes back with an error: "Cannot insert duplicate entry in field pk_Trunk". The above field is the primary key identity field.

Has anyone experienced this strange problem?

---


Ok, I re-seeded the table and the problem seems to be sorted. Don't know why it happened in the first place though.

We have had this problem (I'll try and find it). In the mean time have you tried the DBCC REINDEX, DBREPAIR and CHECKDB comands? You may need to run these nightly depending upon your own maintenance schedule.

Well, thanks for the responce but we've cracked it now. :)