Viewing the Locks in MS-SQL
 |
The article you are reading has moved! It is now available at: http://blog.tinisles.com/2005/11/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:
Labels: mssql
