Post reply

How do i perform Distributed Transactions in SQL Server 2000?

  • August 31, 2005 at 7:56 am

    #90650

    Hi,

    I'm getting the following error when i tried to run a script which updates 2 different rows in two diffrent servers.

    Server: Msg 7391, Level 16, State 1, Line 110

    The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

    [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

    Follwing is the query i'm using in script.

    BEGIN TRANSACTION

     UPDATE Relocation_Accounting_Service  SET   ErasEnabled  = @ErasEnabled

       ,UpdateDt  = @UpdateDt  WHERE TransId = @TransId     

                                                              

      UPDATE IC2.IC2.DBO.Customer_file SET  UpdateID = @UpdateUserId

       ,UpdateDt = @UpdateDt WHERE TransId = @TransId

    I tried giving BEGIN DISTRIBUTED TRANSACTION, but still same problem persists.

    Can anyone give any suggestions?

     

     

  • August 31, 2005 at 8:36 am

    #586493

    Have a look in BOL (Books on Line) about distributed transactions (lots to read) and check that you have everything required in place for this to work.

    /Kenneth

  • August 31, 2005 at 8:38 am

    #586495

    http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql

    Kindest Regards,

    Vasc

  • September 1, 2005 at 3:38 am

    #586759

    I got solution for this.

    I need to set XACT_ABORT on in that session.

    thanx for u'r suggestions.

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

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