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