I am trying to execute procedure through linked server ,
but after executing the same it is giving me following error.
OLE DB provider "SQLNCLI" for linked server "XYZ"
returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 18
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "XYZ" was unable to begin a distributed transaction.
I have already enabled remote inbound and remote outbound from MS DTC settings in component service.
For Info. I am using SQL Server 2005 enterprise edition and Windows 2003 enterprise on both the machines.