I have requriment of update data in a linkedserver SQL Server from a Trigger.
How Ever, I am getting follwing error when I tried it.
Update can be done from simple query and it is failing only in Trigger.
OLE DB provider "SQLNCLI" for linked server SOURCESERVER returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Procedure TR_U_DimClient_sanj, Line 32
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server SOURCESERVER was unable to begin a distributed transaction.
I have set XACT_ABORT ON and REOMTE PROCEDURE ON also MSDTC is also running. HOSTS file is also updated.
both servers named servers. Is that can be the problem