Blog Pages

The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction

Try to do:
DISTRIBUTED TRANSACTION in try-catch block.

Error message:
The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.

Solution:
remove the try-catch block and see the exact error. then fix it - it probably some 'standard' SQL error.

but - if you want/need to see the errors:
run dynamic sql from the linked server to the current one:

No comments:

Post a Comment