--查看被锁的表
select request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName from sys.dm_tran_locks
where resource_type = 'OBJECT '
--解锁
kill 表ID ,表ID
select request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName from sys.dm_tran_locks
where resource_type = 'OBJECT '
--解锁
kill 表ID ,表ID