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