Orphaned Distributed Transaction Found

An orphaned distributed transaction has been found, which can lead to performance and stability issues. Try to locate the cause and use the generated KILL query to remove it. If that fail, try to remove the transaction using Component Services (see Further Reading),

Suggested Action

đź’ˇ Select 'Suggested Script' for an automatically generated script.

Track down the orphaned DTC session and close it, or kill the connection.

How to Kill an Orphaned Distributed Transaction Connection

KILL 'D5499C66-E398-45CA-BF7E-DC9C194B48CF';

Further Reading

​How to Kill a Blocking Negative SPID in SQL Server | MSSQLTips.com

KILL (Transact-SQL) | Microsoft Docs