锁表解决方法

 

 

查询所有进程

SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName
FROM sys.dm_tran_locks
WHERE resource_type='OBJECT'

 

杀死进程

kill 62

posted @ 2022-04-24 14:58  泉城余文乐  Views(34)  Comments(0Edit  收藏  举报