(Jack Vamvas) I outlined in MS DTC and sys.dm_tran_active_transactions and SQL Server detected a DTC/KTM in-doubt transaction with UOW , how orphaned distributed transactions are created. This query deals with alleviating the immediate problem . Root cause analysis should follow.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help