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 ...

[LINKEDSERVER].TBRWeb.dbo.TeamMaster TM ON TS.TeamID = TM.TeamID WHERE Project = 1 ORDER BY StatsDate DESC, OverallRank ASC </pre><BR><BR>So, to answer your question, SQL Server seems to be smart ...