SQL Server 查看被锁的表

 1、查看被锁的表

SELECT  request_session_id spid ,
        OBJECT_NAME(resource_associated_entity_id) tableName
FROM    sys.dm_tran_locks
WHERE   resource_type = 'OBJECT';

 2、解锁

DECLARE @spid INT; 
SET @spid = 119;
 --锁表进程
DECLARE @sql VARCHAR(1000);
SET @sql = 'kill ' + CAST(@spid AS VARCHAR);
EXEC(@sql);