Thanks for the link, Sergey. I tried again but I still can't get it to work, but that's ok. I really wasn't looking to update my VFP utility program. I've already tested it and the old SQLDMO seems to work just fine with SQL 2005.
My main reason for posting this was a heads-up to others who might use SQL scripts in this manner to just be careful with the new SQL 2005 Management Studio.
~~Bonnie
>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?