Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003

    Question Unanswered: Avoiding the usage of DTC


    I am running an script and the following sentence throws and error because the DTC service is not running in the Remote Server:

    insert into MyLocalTable
    execute synonym_MyRemoteProcedure @SomeParameter

    Since a transaction is not declared within the script, why is the DTC required?
    How can I avoid the usage of the DTC? Is there a way to say "this code is not within a distributed transaction"?

    Thanks a lot.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    You are still in an explicit transaction. As far as I know, the requirement that the DTC service be running can not be bypassed. You can try using just a select statement to get the data from the remote server, as the "black box" nature of the stored procedure may be causing this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts