Orphaned MSDTC transactions (-2 spids)

Orphaned MSDTC transactions (-2 spids):


select distinct(request_owner_guid) as [UoW ID] from sys.dm_tran_locks where request_session_id = -2  --- SQL Server 2005 onwards


go

select distinct(req_transactionUoW) as [UoW ID] from syslockinfo where req_spid = -2  -- SQL Server 2000
  go   Then to kill the transaction in SQL Server, follow the command
kill {'UoW ID'}

where {UoW ID} is the result of the above select statement.

References:

http://www.eraofdata.com/orphaned-msdtc-transactions-2-spids/