–查看被鎖表：
SELECT ????request_session_id?spid, ????OBJECT_NAME( ????????resource_associated_entity_id ????)?tableName FROM ????sys.dm_tran_locks WHERE ????resource_type?=?'OBJECT'? ORDER?BY?request_session_id?ASC --spid???鎖表進程? ????--tableName???被鎖表名
–根據(jù)鎖表進程查詢相應進程互鎖的SQL語句
DBCC INPUTBUFFER (249)
?— 解鎖：
?DECLARE ????????@spid?INT ????SET?@spid?=?52--鎖表進程 ????DECLARE ????????@SQL?VARCHAR?(1000) ????SET?@SQL?=?'kill?'?+?CAST?(@spid?AS?VARCHAR)?EXEC?(@SQL)
?–生成解鎖SQL
SELECT ??DISTINCT??'DECLARE?@spid?INT?SET?@spid?=?',request_session_id,'?DECLARE?@SQL?VARCHAR?(1000)?SET?@SQL?=?''kill?''?+?CAST?(@spid?AS?VARCHAR)?EXEC?(@SQL);'??as?s FROM ????sys.dm_tran_locks WHERE ????resource_type?=?'OBJECT'???--spid???鎖表進程? ????--tableName???被鎖表名
? 版權聲明
文章版權歸作者所有，未經(jīng)允許請勿轉(zhuǎn)載。
THE END
