I've got an ASP.NET app w/ a SQL backend. The SQL backend has a linked server (Access db) that is has several views that call from the linked tables.<BR><BR>Everything works fine in QA and Enterprise ...

</pre><BR><BR>So, to answer your question, SQL Server seems to be smart enough to pass as much of the query as can be executed remotely over there, prior to executing portions that need to be executed ...