Is it possible to force a query to ignore the server option "remote proc transaction promotion" so it doesn't promote remote proc transaction?
Using INSERT INTO...EXEC AT linked server into temp table fails with Msg 7391