Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Auto-Increment

Author  Topic 

sujith.it
Starting Member

1 Post

Posted - 2008-07-23 : 06:39:58
Hey,

Here is what happened:

Users for a long time have been able to post new topics in our forums. However, a short time ago, the some users began to experience problems. What I have narrowed it down to is that upon inserting into the table, sometimes id value for the topic is the same as an id that is already in the table, so it fails to insert the record (due to a constraint). However, the topic id column is an auto-increment column and should just assign the next number for the id value.

Any ideas?
____________
[url=http://www.hotels-london-hotel.com/]London hotels from Hotels in London ltd[/url] [url=http://www.hotbuckles.com/rhinestone-belt-buckles-c-62_32.html]Rhinestone Buckle[/url]

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-23 : 06:47:15
can you show us the ddl for your table?

Em
Go to Top of Page
   

- Advertisement -