Locks and Locking

SELECT
locktype  = CASE
WHEN master..syslocks.type = 1 THEN ‘Exclusive table lock’
WHEN master..syslocks.type = 2 THEN ‘Shared table lock’
WHEN master..syslocks.type = 3 THEN ‘Exclusive intent lock’
WHEN master..syslocks.type = 4 THEN ‘Shared intent lock’
WHEN master..syslocks.type = 5 THEN ‘Exclusive page lock’
WHEN master..syslocks.type = 6 THEN ‘Shared page lock’
WHEN master..syslocks.type = 7 THEN ‘Update page lock’
WHEN master..syslocks.type = 8 THEN ‘Exclusive row lock’
WHEN master..syslocks.type = 9 THEN ‘Shared row lock’
WHEN master..syslocks.type = 10 THEN ‘Update row lock’
WHEN master..syslocks.type = 11 THEN ‘Shared next key lock’
WHEN master..syslocks.type = 256 THEN ‘Lock is blocking another process’
WHEN master..syslocks.type = 512 THEN ‘Demand lock’
END,
*
FROM master..syslocks
where id <> 0
–and dbid = 19
ORDER BY master..syslocks.spid