You can find three part article 'Manage SQL Server from VFP' by Andrew Coates at http://www.civilsolutions.com.au/publications.htm

>OK - I give up.
>
>I have only ever used VFP is XBASE mode.
>
>We got MSDE with VFP7 which is (presumably) functionally equivalent to MSSQLS.
>
>But how do we us it?
>
>Programatically, what do I do to use the server?
>
>What are the commands to create a new database, create a new table, etc. I know how to use Views - and presumably we use remote views to manipulate the database - but what happens when we want to create a new database on the fly?
>
>And where are our tables stored?
>
>David.
>
>PS This is my Christmas project - get across MSDE/SQLS so I can promise client/server applications to my clients IF I can't talk them out of it!