查看SqlServer被锁表以及解锁

查看被锁的表

SELECT request_session_id AS [事务ID],
       OBJECT_NAME(resource_associated_entity_id) AS [被锁表名]   
FROM   sys.dm_tran_locks
WHERE  resource_type='OBJECT'

解锁

kill 事务ID
比如： kill 201