>Hi,
>
>I am looking at ways to do some SQL server (and MSDE) maintenance from within VFP, like installing MSDE, modifying tables, indexes, etc.
>
>MS offers on its site a VB project that seems good to stard with, but nothing for VFP. Does anybody know about a VFP version or another practical solution? Thanks.
>
>Patrice

The easiest way to do this seems to be the SQPDMO (Data Maintenance Objects) which allow you to modify tables etc with a COM interface.

The SQL Docs have info of these objects.

Bob