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