SQL Server查看锁表与解锁表

--查看被锁表
SELECT
request_session_id spid,  --锁表进程ID
OBJECT_NAME(
resource_associated_entity_id
) tableName                --锁表表名
FROM
sys.dm_tran_locks
WHERE
resource_type = 'OBJECT'
ORDER BY request_session_id ASC

--解锁
DECLARE
@spid INT
SET @spid = 185--锁表进程ID
DECLARE
@SQL VARCHAR (1000)
SET @SQL = 'kill ' + CAST (@spid AS VARCHAR) EXEC (@SQL)

收藏参考原文链接

https://www.cnblogs.com/LukeSteven/p/15131909.html--查看被锁表SELECT request_session_id spid, --锁表进程ID OBJECT_NAME( resource_associated_entity_id ) tableName --锁表表名FROM sys.dm_tran_locks WHERE resource_type ='OBJECT'ORDERBY request_session_id ASC--解锁DECLARE@spidINTSET@spid=185--锁表进程IDDECLARE@SQLVARCHAR (1000) SET@SQL='kill '+CAST (@spidASVARCHAR) EXEC (@SQL)