Skip to content

Viewing the Locks in MS-SQL

select so.name, sli.*, sp.* 
from 
    sysobjects as so 
    join master..syslockinfo as sli on sli.rsc_objid = so.id
    join master..sysprocesses as sp on sp.spid = sli.req_spid
where xtype = 'U'

System tables reference:

Post a Comment

Your email is never published nor shared. Required fields are marked *