>Hi,
>
>I'm somewhat new to SQL2000. I deployed my app from my SQL2000 to my clients site via BACKUP and RESTORE commands. That seemed to work great. I now have made a bunch of table modifications, added/changed/delete fields from my development SQL2000. When using Foxpro I've always used SDT to update my clients data structions. How can I update my clients data structures with SQL2000?
>
>
>Thanks for your help.
>
Steve,
You could use SQL-DMO from your VFP application to make the necessary changes. A good place to start would be by doing a search in the Books On-Line for the phrase SQLDMO.Database. I've yet to find anything that you can do from the SQL Server Enterprise Manager that you can't do with SQL-DMO.
George
Ubi caritas et amor, deus ibi est