Hello,

you may want to check out the Universal Thread Magazine,
in one of the past issues there was an article on handling SQL-Server data with VFP, i also remember some good articles called "TSQL Primer for VFP-Developer Part 1-3" which introduces how to work with stored procedures of SQL-Server from VFP.

working with SQL server involves nothing special, but to take Nelsons message into consideration, i would no go the ADO way .. (at least as long as i'm not working with VFP8) cause integrating ADO into a VFP app is a real pain (no databinding and so on .., much handcoding to do, in VFP8 there are some new features that would it eventually make it an alternative), not to say that it is slower than plain ODBC (own tests showed that)

just start by creating a new ODBC connection to the SQL Server and
then in your DBC create a connection to this ODBC-DataSource and play a bit with remote view's

Regards

Christian