Thanks for the correction. In the BOL topic for the KILL command (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/071cf260-c794-4b45-adc0-0e64097938c0.htm) it says:
to terminate orphaned distributed transactions. These transactions are not associated with any real session ID, but instead are associated artificially with session ID = '-2'. This session ID makes it easier to identify orphaned transactions by querying the session ID column in
dynamic management views.
Would this be just an instance of unclear/incomplete documentation? Do you have a better reference on this topic?
Monday, June 09, 2008 3:20 PM
RE: SPID = -2
Be careful (-2) does not mean orphaned. It means you have an open DTC transaction managed by an external ITransaction interface but no Sessions currently using it.