赞
踩
(1)下面是查询死锁进程
select
request_session_id spid, (死锁进程id)
OBJECT_NAME(resource_associated_entity_id) tableName (死锁进程名称)
from sys.dm_tran_locks
where resource_type='OBJECT' (数据类型所有)
(2)杀死死锁进程
declare @spid int //声明id
Set @spid = 62
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。