SqlServer表锁住后...
索引
SqlServer表锁住后,必须手动杀掉死锁的会话ID,才能恢复正常,相关操作:
查看被锁表:
select request_session_id
spid,OBJECT_NAME(resource_associated_entity_id) tableName from
sys.dm_tran_locks where resource_type=‘OBJECT’
–spid 锁表进程
–tableName 被锁表名
解锁:
declare @spid int Set @spid = 57 -
原创
2021-01-06 09:53:05 ·
296 阅读 ·
0 评论