--这两句在master上操作
SELECT blocking_session_id '阻塞进程的ID', wait_duration_ms '等待时间(毫秒)', session_id '(会话ID)' FROM sys.dm_os_waiting_tasks
杀死进程
exec Sp_KillAllProcessInDB 'melife'
--这两句在melife上操作
select *
from master..SysProcesses
where db_Name(dbID) = 'melife'
and spId <> @@SpId
and dbID <> 0
and blocked >0;
杀死进程
exec dbo.sp_who_lock