I'm working on SQL Server 2008, and the problem I have is that I can not (I do not know if it's really possible) to insert records from a query from a Store Procedure from another server:
declare @DRIVER Table
(drive char(1), FreeMB int)
INSERT @DRIVER
EXEC DYSNOMIA.MASTER..xp_fixeddrives
ERROR: "OLE DB provider" SQLNCLI10 "for linked server" DYSNOMIA "returned message" The partner transaction manager has disabled its support for remote / network transactions. ".
Mens. 7391, Level 16, State 2, Line 4
The operation could not be performed because the OLE DB provider "SQLNCLI10" for linked server "DYSNOMIA" was unable to begin a distributed transaction. "
Even if it works for me if I just run the procedure remotely (The last line)
Additional Configuration Data:
