Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to kill users who has blkby
Message
From
11/08/2007 02:34:49
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
 
To
10/08/2007 05:05:36
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01247293
Message ID:
01247600
Views:
21
Hi,
Do the Blocked Session ID's have a value of '-2', if so they are orphaned. Just stop and restart MSDTC.

>Dear All,
>
>How to kill users who has blkby <> . at once ?
>
>currenly, I am running it manually
>
>sp_who2
>kill
>
>one by one
>
>Please help
>
>Thanks & Regards
>Winanjaya
Regards N Mc Donald
Previous
Reply
Map
View

Click here to load this message in the networking platform