杀死死锁进程

--检索死锁进程

use master

go

select spid, blocked, loginame, last_batch, status, cmd, hostname, program_name

from sysprocesses

where spid in

( select blocked from sysprocesses where blocked <> 0 ) or (blocked <>0)

--杀死指定进程

kill spid

如果觉得《杀死死锁进程》对你有帮助，请点赞、收藏，并留下你的观点哦！