SQL锁表查询

--查询已锁的表
select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName ,*
from sys.dm_tran_locks where resource_type='OBJECT'

 

--查询已锁的表

select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName 

from sys.dm_tran_locks where resource_type='OBJECT'

 

--结束锁表的进程

kill 72