Monthly Archives: April 2015 - Page 34

How to check locks held by SQL Server


sp_getapplock
sp_releaseapplock

also check sp_MSacquireSlotLock & sp_MSreleaseSlotLock used in merge replication process