The transaction manager has disabled its support for remote/network transactions.

Esta es la solución a un error que estaba ocurriendo cuando trataba de guardar una consulta hecha por medio de un procedimiento almacenado, apuntando a un servidor vinculado (Linked Server), en una tabla temporal.

OLE DB provider "SQLNCLI10" for linked server "SQLVillage" returned message "The transaction manager has disabled its support for remote/network transactions.". 
Msg 7391, Level 16, State 2, Line 2
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "SQLVillage" was unable to begin a distributed transaction.

Lo solucione realizando los pasos que indica la siguiente pagina web en el servidor SQL donde esta instalado la base de datos:

http://www.sqlvillage.com/Articles/Distributed%20Transaction%20Issue%20for%20Linked%20Server%20in%20SQL%20Server%202008.asp

Cortesía de Gustavo Guzman