>We're starting a new VFP/SQL Server project and have been discussing the benefits/pros & cons of using remote views versus SQL passthru. We'd be interested in any opinions on this debate and experiences from your point of view and work you've done/are doing.
>
>By the way, this will be done ourselves, we're not interested in a framework or "tool" to do this for us. :)
>
>Thanks.

Mark,

Try Integrating SQL Server with Visual FoxPro. It's a technical paper by Robert Green. It examines the pros and cons of views and SPT.

Hmm for some reason the whole thing is underlined. Just hit the first part of it ("Integrating") and it should work.