>>>first of all i feel great that i finally found something that is letting me define my problem in details. so here it goes
>>>We are currently working on ERP solution in Visual fox pro 6 and its incomplete. the main reason of this post is simple.
>>>i want to create a setup file that installs application on a local computer but connects to sql 2008 for database operation. i do NOT want to save data in local dbf . i want my data to be stored in sql 2008 r2. awaiting respones.
>>
>>What's the question?
>>
>>Tamar
>
>the question is to use sql 2008 r2 as my database and datasource

Should work - the SPT mechanism didn't change between VFP6 and VFP9. Now other SQL*() functions, like sqlcolumns(), or using ?-prefixed parameters inside a SQL statement, that may have some quirks, but generally it should work. VFP isn't talking to the SQL server directly, it's talking to the ODBC driver, so if you have trouble using the latest driver (though you shouldn't have any, they all stick to the 20+ year old specs), you can try using an older driver, say the one for SQL 2000. I've seen that driver work with SQL 2008.

Try with SQL 2008 express. If your app works with it, then it will work with the regular SQL 2008 as well.