|
-
Jul 1st, 2002, 05:00 AM
#1
Thread Starter
Fanatic Member
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.
Last edited by simonm; Jul 1st, 2002 at 05:07 AM.
Everything I say is either loose interpretation of dubious facts or idle speculation rooted in irrational sentiment. 
-
Jul 1st, 2002, 05:15 AM
#2
Fanatic Member
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.
The liver is bad. It must be punished.
-
Jul 1st, 2002, 05:16 AM
#3
Thread Starter
Fanatic Member
Well, thanks for the responce but we've cracked it now. 
Everything I say is either loose interpretation of dubious facts or idle speculation rooted in irrational sentiment.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote