Don't use ADO, use SQLDMO instead. Both are object based programming API's.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...
Quote:> How can I do that?
1. Generate SQL script for all objects in a database - but using ADO,not SQL-DMO
How can I do that?
3. Generate SQL Script for all objects in a database programmatically using TSQL
5. Pb. Database creation using generated Oracle scripts
6. Accessing the resultset of a select statement IN stored procedure...
7. Using SQL to generate Trigger creation scripts
9. newbie Q: generating object creation scripts
10. Generate MS-ACCESS table using SQL Script generated by SQL Server
11. Database Creation Scripts - How to Generate?
12. Generate SQL database object script
13. Queries related to Creation of database,tables and indexes using SQL scripts