create tables from sqldmo

[meravsha]

I wrote a script with 50 tables definition It's called:
NewTables.sql
my question is: How can I run this script from vb6 -> sqlDmo?

 

[rdroske]

With MS SQLServer I would just create a stored procedure and execute that from VB by issuing an SQL statement like EXEC stored_procedure_name?

 

[zemp]

You can also create an SQL statement to create your tables and execute it through an ADO connection.

There are SQLDMO examples available for download at

http://www.planetsourcecode.com

as well. Including this complete enterprise manager clone.

http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=40912&lngWId=1

Take Care,

zemp

"If the grass looks greener... it's probably because there is more manure."