SYSTEM: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Developer Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor)
PROBLEM: Today I encountered an "orphaned transaction" (SPID -2) with a Unit of work ID of 00000000-0000-0000-0000-000000000000
I tried executing kill '00000000-0000-0000-0000-000000000000', but got a message that this could not be done. (Sorry, I failed to capture the exact message)
There were two transactions open in the MS DTC, but they were not set to in-doubt for a status, so I could not kill them from there.
At length, I resolved this by restarting the MS DTC.
This is a development system, so absolutely anything might have happened to cause this.
QUESTIONS: I was just wondering if anyone had seen it, and might have any insights into:
A) What might cause it
B) If there is a more elegant way to resolve