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.