I could have sworn I saw a spid with a negative number .
Am I hallucinating or has anyone seen that before ?I have seen processes being blocked by a negative spid. Its usually a
sign of an orphaned DTC transaction.|||That's right. See KILL in the SQL 2000 Books online.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<bkrish1@.gmail.com> wrote in message
news:1139376225.767527.251290@.o13g2000cwo.googlegroups.com...
>I have seen processes being blocked by a negative spid. Its usually a
> sign of an orphaned DTC transaction.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment