SQL Server查锁表和解锁表
检察被锁表：select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
from sys.dm_tran_locks where resource_type='OBJECT'
--spid 锁表进程
--tableName 被锁表名
解锁：
sql='kill '+spid
SELECT * FROM sys.dm_tran_locks;
SELECT request_session_id spid, OBJECT_NAME(resource_associated_entity_id) AS TABLE_NAME
FROM sys.dm_tran_locks
--WHERE resource_database_id = 16
--WHERE resource_type = 'OBJECT';
SELECT request_session_id spid, resource_associated_entity_id AS TABLE_NAME
FROM sys.dm tran locks;
--kill ;
commit;
-------------------------------------------------------------------------------------------
SELECT * FROM sys.sysprocesses order by login_time desc;
SELECT * FROM sys.syslockinfo;
SELECT * FROM sys.syslockinfo AS LO
INNER JOIN sys.sysprocesses AS P ON
LO.req_spid = P.spid
order by login time desc;
-------------------------------------------------------------------------------------------
exec sp_lock; https://i-blog.csdnimg.cn/direct/e7d5bb281ab643ac90801106550ec0d3.jpeg
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
页:
[1]