Kill Deadlock process

Hello All,
How do you kill deadlock process effectively beside rebooting the sql server?
Thanks.
Hi davis,
It depend upon what type of dead lock u have i mean u have dead lock on
distrubuted transaction or local transaction.
to kill the dead locks u can use
KILL 54 to kill the spid
KILL 54 WITH STATUSONLY
if u want to kill all the deadlock at a time
query this
hope this help
from
killer
|||A true deadlock will clear itself. The deadlock victims gets a 1205 error
and the winner just continues. Are you sure its a deadlock?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"David" <David@.discussions.microsoft.com> wrote in message
news:F43E8AE7-69E5-4A2F-920D-BB070DB75E7B@.microsoft.com...
Hello All,
How do you kill deadlock process effectively beside rebooting the sql
server?
Thanks.