Hi All,

I am getting below error while inserting into Linked Server (sql2012) thru trigger from sql2008 ....However if i insert the same thru Store Procedure it is inserting successfully....MSDTC service is started on both sql server machines....also both machines rebooted....but still i am facing this error.


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

Could assist to resolve.

 
OR
 
Is it allowed to insert into linked server thru trigger ? 
 

Regards

Shehzad