>We are converting a VFP 9.0 application with the Mere Mortals framework to SQL Server. Using Visual FoxPro as a front end, would it be better to use Stored Procedures or Remote Views to access the data through SQL Server? Is there a built-in method in the framework to access data using Stored Procedures?
>

I don't think there is going to be any huge difference, more just a matter of preference. I have done it both ways, as well as SQL Pass-Through. The general rule is you will get better performance from a stored procedure but I haven't seen anything noticeable.

It's very easy to call a SP from VFP. You get a database connection, issue SQLEXEC(), and disconect. The SQLEXEC will look something like this:

lnRetVal = SQLEXEC('EXEC MyStoredProcedure')

You can include parameters in the command string if they are needed.

Caveat: I have not done any formal performance testing of the different methods, this is just my sense that there isn't much difference. Maybe someone else here has done something more formal.