Unable to begin a distributed transaction RRS feed

  • Question

  • Hi All,

    Can someone help me to troubleshoot the below error?

    I am getting the error executing the below code.

        drive char(1) Primary Key,
        freespace int null

    Insert into #Drive
    EXEC TESTSERV.MASTER.xp_fixedDrives

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

    Monday, October 23, 2017 12:22 PM

All replies