I built a trigger that activates another trigger (Nested Trigger).
The First trigger which is located on table A inserts data into table B and in return the second trigger which is located on table B updates data in table A.
The whole process works fine when both tables are on the same server but when the tables are on different servers i get the following error:
"[Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be performed because the OLE DB Provider 'SQLOLEDB' was unable to begin a distributed transaction.
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator.]"