Hi Gary..

Remote Views, at best, is an incomplete wrapper around SPT. RV's require you to ceded to much control. Further, if you are going to employ best practices with respect to SQL Server Development, you will use Stored Procedures to Update, Insert, Delete, and Query Data. Stored Procedures provide the level of security and control that developers and DBA's need.

That said, RV's do not support Stored Procedures.

I am a member of a team that successfuly deployed a VFP/SQL application that was migrated from an existing FPW application. Here are the stats:

500+ users (simultaneous)
100+gb database
24x7
Stored Proc - Driven
No DBC or Remote View Use - use SPT and ADO instead....

Remote views do not scale....period.

If you care to chat about this privately, send me an e-mail...



>We have just installed our first SQL Server and plan to migrate current VFP applications.
>Can someone provide me with a resource or suggestions on when to use remote views and when to use SQL Passthrough
>
>
>Thanks
>Gary in Cloudy Dallas