We have the same situtation. As stated in the previous post we do use the UPDLOCK as show below :

Select @SerialKey = SerialKey

From SerialKey WITH ( ROWLOCK, UPDLOCK )

We...