Forum Discussion
Linked Server Selection Query Fails with "MS DTC has stopped this transaction"
Hi everyone, I’m currently setting up a Linked Server from our head office (server A) SQL Server to a subsidiary unit (Server B) SQL Server. The Linked Server connection tests successfully, and I c...
Try using Openquery. Besides being less problematic with syntax it also issues the command remotely so it can be faster than direct linked server queries because it sends the entire query to the remote server for execution. This means the remote server handles parsing, optimizing, and executing the query, reducing the workload on the local server.