Home > IT Blogs > SQL Server with Mr. Denny/

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...

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

1