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.
| Author |
Topic |
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
 Posted - 2006-10-31 : 05:52:27
|
| Hi Everyone, I have a table Called Table1, which has around 120 columns. The primary key of the table is the indentity field with the increment of 1. Now here is the problem, when the 2 or more users are trying to save the record into the table, one of the user is getting proper value of the primary key(Incremented from the previous one) where as the other user is getting the value 9. And the record which is on 9 previously is getting deleted. There are no trigger on the table, i am justing adding the record using REcordSet function of AddNew(). Secondly i invastigated on it, and this is not happening all the time, only some time. may be after inserting around 12-15 record this case arrises. Any pointers on what should i do?Chiraghttp://chirikworld.blogspot.com/ |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-31 : 05:57:03
|
| Are you using SCOPE_IDENTITY() ?Peter LarssonHelsingborg, Sweden |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-10-31 : 05:58:59
|
| Nopes, its just a normal table with the identity column as the primary key.Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
|
|
|
Indentity Issue.