Hi Michael, this is what I was dreading- having to re-create everything as pass through queries. After reading your post, I started reading up more on pass through queries and what syntax difficulties to expect.
I posted on a similar topic a couple of weeks ago, before doing the SQL Server...