We are about to undertake a massive rewrite of one of our apps and have made the decision to move to SQL Server for data storage instead of VFP tables.

We are undecided on using remote views or SQL passthrough for accessing the data. I realize that using SQL passthrough I will have the ability to fire stored procedures and can't do this with remote views. Other than that is there a performance benefit from either.

One problem we may run into is that a user may leave the system running on their workstation for an extended period of time. Will either method allow that users system to see changes made by others on the network without requerying the db with either of these methods?

One last thing... In real world example what is the benefit of using stored procedures in a desktop application?

Thanks...
Tommy