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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2011-03-17 : 06:53:20
|
| Are there any issues using autonumber as an id and identifier in a multiuser environment.There were issues with this in Access |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2011-03-17 : 07:32:16
|
| Are you meaning IDENTITY |
 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-03-17 : 07:38:45
|
| Assuming you are referring to identity, I can't think of any problems other than the normal issues that you may be faced with in a multi-user/multi-threaded environment. When you want to retrieve identity values distinguish between @@scope_identity or @@identity depending on what you are trying to accomplish. |
|
|
|
|
|
|
autonumber