Hello gentlmen and gentlewomen. I am playing around with OPENQUERY to
make joins across linked servers with the idea of distributing
processing to improve performance.



SERVERA



Select

Stuff

From OPENQUERY(SERVERB, 'select stuff

from serverB table

join serverB table

join linked serverA table)





The reason I want to do this, is the server B joins are large record
sets but the join to serverA reduces the records set to something small
enough to send over the network back to serverA. But I get this error.
Any clues?











Server: Msg 7391, Level 16, State 1, Line 1

The operation could not be performed because the OLE DB provider
'SQLOLEDB' was unable to begin a distributed transaction.

[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]

OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].


MS Sql Server LazyDBA home page