I have a problem with catching DTC attention in a trigger. I copy data in AFTER INSERT trigger from server A to server B. If the server B goes unavialable for few seconds (probably overloaded), the copy process cannot be finished and everything rolls back including commiting inserted data on A.
I receive the following ODBC error which passes the TRY...CATCH block in the trigger
SQLExecDirect failed! sqlstate = 42000; native error = 1206; message = [Microsoft][ODBC SQL Server Driver][SQL Server]The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.