InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 11:07:30 GMT20http://www.sqlservercentral.com/Forums/Topic1405378-392-1.aspxSorted, as I'm only using the Linked Server for this activity I've configured it to ignore remote proc transactions.EXEC master.dbo.sp_serveroption @server=N'XX.XXX.XX.XX', @optname=N'remote proc transaction promotion', @optvalue=N'false'Thu, 10 Jan 2013 07:22:04 GMTgiles.claphamhttp://www.sqlservercentral.com/Forums/Topic1405378-392-1.aspxSorry mislead you, the servers are on different Domains.Thu, 10 Jan 2013 06:50:21 GMTgiles.claphamhttp://www.sqlservercentral.com/Forums/Topic1405378-392-1.aspxHello,I'm working with 2 servers both SQL Server 2008 R2 on the same Domain. One of these servers has a Linked Server to the other.I can quite happily execute a stored procedure that resides on the linked server from the other however if I try to save the results into a temp table I get the following error."OLE DB provider "SQLNCLI10" for linked server "xx.xxx.xx.xx" returned message "The partner transaction manager has disabled its support for remote/network transactions.".Msg 7391, Level 16, State 2, Line 1The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "xx.xxx.xx.xx" was unable to begin a distributed transaction."MSDTC is running on both servers. The RPC Out is set to true on the linked server.Could anyone tell me what the difference is between executing and savign the results to a temp table, and secondly how to work around the problem.ThanksGilesThu, 10 Jan 2013 06:20:03 GMTgiles.clapham