Hi Bonnie,
I didn't get to work with SQL 2005 yet so cannot help you much. Maybe this link can help
http://www.sqldbatips.com/showarticle.asp?ID=34>Hey, Sergey ... thanks for the info. Any idea how to instantiate these objects in a VFP program? The utility we currently use for maintaining our SQL Server database was a utility I wrote many years ago in VFP ... it was easy to store the script for schema changes in a VFP table, plus I knew how to use SQLDMO from VFP and, at that time, I hadn't quite learned .NET yet. It's the only VFP app we use as our main app is all .NET.
>
>In VFP, I instantiate the DMO object like this:
>
>
>LOCAL loSQLDMO AS SQLDMO.SQLServer
>
>
>I've tried various combinations to try and instantiate SQLSMO, but with no luck. Any idea of the correct syntax?
--sb--