Rankatan,

Попробовал именно, как вы советовали. Получаю ошибку:
OLE DB provider "SQLNCLI11" for linked server "SERVER1" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Procedure SERV_CONNECT, Line 17
The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "SERVER1" was unable to begin a distributed transaction.