I have an error when connect to local sql server 2008 to online sql server 2008.
OLE DB provider "SQLNCLI" for linked server "xx.xxx.xxx.xxx" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Procedure reminder, Line 5
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "xx.xxx.xxx.xxx" was unable to begin a distributed transaction.