locked
Inserting data into table through linked server RRS feed

  • Question

  • Hi

    I am trying to insert data from a remote database into my database using linked server.

    Below is the syntax that I am using

    set XACT_ABORT on
    INSERT INTO MyTable
    EXEC [172.xx.xx.xxx].MyDatabase.dbo.[MyStoredProc] '2014-10-20','2014-10-26'  

    When I execute the SP (EXEC [172.xx.xx.xxx].MyDatabase.dbo.[MyStoredProc] '2014-10-20','2014-10-26'   ) I get the result.

    but when I try inserting the data into a table using the above code I get the following error

    OLE DB provider "SQLNCLI11" for linked server "172.xx.xx.xxx" returned message "No transaction is active.".
    Msg 7391, Level 16, State 2, Line 59
    The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "172.xx.xx.xxx" was unable to begin a distributed transaction.

    I tried solutions given on

    http://stackoverflow.com/questions/7473508/unable-to-begin-a-distributed-transaction

    but still i get the issue... I don't know whats wrong.

    Monday, October 27, 2014 8:07 AM

Answers

All replies