Post reply

Linked Server Insert

  • May 25, 2007 at 8:22 am

    #69818

    Hi,

    I am running following script on server A. Server B is configured as linked server to A.

    SET xact_abort ON

    GO

    begin tran

         INSERT INTO B.table1.dbo.CUSTOMER (CUSTOMER_ID,PLAN_CODE)

         VALUES (1001,100)

         rollback tran

    The above script when run run on server A gives following error:-

    Error..

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

    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. ]

    OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

    Pls. advise why this error occurs. How to insert records in linked server.

  • May 29, 2007 at 3:54 am

    #709286

    Hi,

    I'm newbie for SQL server but I tried to help you out on this. I ever encounter the same problem when we upgrade the O/S from windows 2000 to windows 2003. It's due to MSDTC is disabled by default in windows 2003.

    You may refer to the KB below for details:

    http://support.microsoft.com/kb/839279

    Hopefully it helps and let me know if you need the screen snapshot.

     

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

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