Mike,
I'm not sure how this will speed performance. I know that in SQL server this can be faster because the SPs are compiled and optimized in advance. I don't see how you'll get a performance benifit doing this with VFP data, though.
>VFP data files can be used successfully over a WAN, but you'll get optimal performance by using SQL Passthrough to call stored procedures to retrieve the data.