DTC via LinkedServers

  • Eric P. Melillo

    SSC Rookie

    Points: 47

    Q: Is there a maximum number of errors that DTC can handle before it throws the error: "Distributed transaction aborted by MSDTC"?

    I have been given "rerunnable" code for a data migration by the developers and for the last 4 runs it has aborted at the same number of data errors being encountered. The abort is not being controlled by the code. Already checked that out.

    Thanks -

    Eric P. Melillo

    Manager, Database Operations

    Onvia

  • Eric P. Melillo

    SSC Rookie

    Points: 47

    Sorry forgot to add the environment:

    Controlling env for transaction:

    SQL Server 7

    Remote (insert) server

    SQL Server 2000

  • Andy Warren

    SSC Guru

    Points: 119694

    With a remote server you might be getting a timeout. I dont use DTC a lot, thought that most any error would cause the transaction to abort. You might try testing it without being in a transaction, see if you can see the error happen. What error message(s) are you getting?

    Andy

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply