SQL Server 查找锁住的对象，并解锁释放

--1.查找到锁住的对象
SELECT 
    T.REQUEST_SESSION_ID SPID
    ,OBJECT_NAME(T.RESOURCE_ASSOCIATED_ENTITY_ID) TABLENAME
    ,T.*
FROM SYS.DM_TRAN_LOCKS T 
WHERE T.RESOURCE_TYPE = 'OBJECT';

--2.杀死进程，释放对象
DECLARE @SPID INT 
SET @spid  = 102                --锁进程
DECLARE @sql VARCHAR(1000)
SET @sql = 'KILL ' + CAST(@spid AS VARCHAR)
EXEC(@sql)