摘要:
杀掉死锁的sqlserver进程
SELECT request_session_id spid,OBJECT_NAME
(resource_associated_entity_id)tableName
FROM sys.dm_tran_locks
WHERE resource_type='OBJECT '
KILL spid号 阅读全文
posted @ 2014-04-21 17:46
上校
阅读(1970)
评论(0)
推荐(0)
浙公网安备 33010602011771号