When I am querying the linked server like select * from [servername].[DBname].[schema].[tablename] it throws an error

'Microsoft Distributed Transaction Coordinator (MS DTC) has stopped this transaction'

But when i run query like select * from openquery([servername],'myquery') it works fine.

So what is the difference between both the query, why it run for 2nd and not the first.

0

There are 0 best solutions below