Post reply

qurey hangs with distributed transactions

  • July 29, 2004 at 2:07 pm

    #360518

    If I write an insert directly to a linked server then it works.
     
    If I do exactly the same via a distributed transaction it hangs. The syntax is 100% correct including the xact_abort on
     
    I'm using sql2000 sp2 with a domain service account. I can't believe the answer is upgrade to sp3a.
     
    Any suggestions gratefully received.

  • July 29, 2004 at 8:15 pm

    #516898

    What OS? Is it on a cluster?

    SET XACT_ABORT ON

    BEGIN TRAN

    insert into linkserver.db.owner.table

    END TRAN

    is that what your transaction looks like?

    Wes

  • July 30, 2004 at 2:14 am

    #516926

    exactly.

    windows 2000 servers in a 2000 domain - not clustered

  • July 30, 2004 at 7:48 am

    #517000

    Well the Distributed Transaction Coordinator controls the transaction and if it can't start or there is an error it will display in the Query Analyzer window. Can you put the error here? There is also a tool from Microsoft called dtcping that will allow you to test the DTC from one server to the target server. After you send the error I'll be more than happy to walk you through using dtcping.

    Wes

  • July 30, 2004 at 8:12 am

    #517035

    Thanks for your help Wes. I'll bear dtcping in mind.

    I've now rebuilt the servers and restored the databases & it's working fine.

    Thanks anyway

Viewing 5 posts - 1 through 4 (of 4 total)

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