查询锁表语句2

栏目:s-hr cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-22浏览:1

查询锁表语句2

查看锁表:


select request_session_id,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT';



杀死锁表进程: kill request_session_id;

查询锁表语句2

查看锁表: select request_session_id,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT'; 杀死锁表进程:kill request_session_id;
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息