SQL Server with Mr. Denny:

sp_getapplock

1

June 7, 2011  9:00 PM

Taking locks without doing SELECT WITH UPDLOCK



Posted by: Denny Cherry
Lock Pages, sp_getapplock, sp_releaseapplock, sys.dm_tran_locks, Transactions

All to often developers need to force some locks on a table so that they can be sure that the records aren’t going to change between the time that they first look at the records and when the transaction is completed.  The most common method that I’ve seen to do this involves at the top...

1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: