>
>If you are using SQL 2000, do the Read/Increment/Update in one command so the row level locking will keep different users from getting multiples. We have been doing this for a while and no dups yet.
>
If you can't do it in one statement then use the UPDLOCK hint to hold the lock and safely update it before the end of the transaction.