-------锁表查询
select request_session_id spid,
OBJECT_NAME(resource_associated_entity_id) tableName
from sys.dm_tran_locks where resource_type='OBJECT'
-------解锁
declare @stabid int
set @stabid = 77 --锁表进程编号
declare @sql varchar(2000)
set @sql='kill '+cast(@stabid as varchar)
exec(@sql)