Active lock sql server
IF we want to know which locks are active in the sql server we can use the following statement
EXEC SP_LOCK EXEC master..SPDBLOCKS 'Database Name'
This will give the SP and Database Id and the object along with its Mode and Status.
Find active lock on the system in sql server was last modified: October 1st, 2017 by