Hi,

I hope this is the appropriate location for this question. I am using SQL Server 2000 on two different servers and have created linked server connections on both of them, so they can communicate with each other.

When I create a query that accesses a remote table on the linked server, how is the where statement evaluated?

I have read contradictory information on the msdn site (although, it's probably just my interpretation that is contradictory). I read that the query will be passed to the linked server and it will be evaluated by the data provider up to its capabilities. On the other hand, I've also read that SQL server will scan the entire remote table and perform the query evaluations locally...

So, when I have a query that accesses data on a linked server where does the 'where' clause get evaluated? Does the provider pass the entire table back to the local server, or only the rows that satisfy the where clause? Where would sorting and grouping take place, on the local server or the provider?

Thanks,

Ranthalion