shohelr2003 (1/16/2013)
If I execute an insert query into linked server, it works. But when I use trigger to execute an insert query into linked server, it fails and generates the following error message."The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "Server2" was unable to begin a distributed transaction."
post the trigger code
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)