--查询已锁的表
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