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),
💡 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
How to Kill a Blocking Negative SPID in SQL Server | MSSQLTips.com
KILL (Transact-SQL) | Microsoft Docs