Forum Discussion
SQL 2016 EXECUTE issue
We recently migrated a database from SQL 2008 to SQL 2016. In the database there is a trigger that executes a remote stored procedure which makes a call on a linked Oracle database. Similar to this...
EXEC requires to enable distributed transaction
see
https://stackoverflow.com/questions/6999906/distributed-transaction-error
https://blogs.msdn.microsoft.com/sqlforum/2010/12/20/faq-how-do-i-configure-sql-server-to-enable-distributed-transactions-via-linked-server/