SQL Server Performance

Distributed transactions on linked servers

Discussion in 'General Developer Questions' started by nilayinc, Sep 4, 2003.

  1. nilayinc New Member

    I am trying to run a transaction in an SP residing on MSDE. The SP makes an insert statement on the remote linked SQL Server.
    I get the following error message :

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

    please advice me.
  2. gaurav_bindlish New Member

  3. satya Moderator

    Nilayinc

    Do not post multiple (duplicate) posts, kindly keep a track and pay attention to the original posts with replies.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  4. gaurav_bindlish New Member

Share This Page