We have a database that we can't restore because any alter database to put it into single_user mode (or offline) will fail because it is blocked by a distributed transaction.
sp_lock -2 shows the following:
spid dbid ObjId IndId Type Resource Mode Status
-2 7 0 0 DB S GRANT
So clearly something has a lock on it.
exec sp_who2
shows no connections for that database.
select req_transactionUOW
from master..syslockinfo
where req_spid = -2
Returns nothing (but the usual 00000000-0000-0000-0000-000000000000)
In the MSDTC coordinantor, there are no transactions marked as "in doubt". There is one active transaction, but we can't commit or abort it since it's not "in doubt".
How do we forcefully remove that lock? Or how do we cancel that transaction in MSDTC