|
-
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. 
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