Home Forums SQL Server 2014 Development - SQL Server 2014 OLE DB provider "SQLNCLI11" for linked server "linkedservername" returned message "The transaction manager has disabled its support for remote/network transactions." RE: OLE DB provider "SQLNCLI11" for linked server "linkedservername" returned message "The transaction manager has disabled its support for remote/network transactions."

  • ayemya - Wednesday, March 7, 2018 10:05 AM

    I appreciate your answers. It explains why my transaction throws errors. we have SQL 2014 AG and it doesnt support DTC. I am trying to think a workaround. Thank you.

    You should be able to do it in Powershell - you can use write-datatable if you are using the SQLServer module. Otherwise the same cmdlet has been written as a function you can download from the TechNet script repository:
    Write-DataTable

    Sue