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  

1. SELECT * FROM sys.dm_tran_locks;
3. SELECT request_session_id spid, OBJECT_NAME(resource_associated_entity_id) AS TABLE_NAME
4. FROM sys.dm_tran_locks
5. --WHERE resource_database_id = 16
6. --WHERE resource_type = 'OBJECT';
8. SELECT request_session_id spid, resource_associated_entity_id AS TABLE_NAME
9. FROM sys.dm tran locks;
11. --kill ;
13. commit;
14. -------------------------------------------------------------------------------------------
15. SELECT * FROM sys.sysprocesses order by login_time desc;
17. SELECT * FROM sys.syslockinfo;
19. SELECT * FROM sys.syslockinfo AS LO
20. INNER JOIN sys.sysprocesses AS P ON
21. LO.req_spid = P.spid
22. order by login time desc;
24. -------------------------------------------------------------------------------------------
25. exec sp_lock;

复制代码

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。