running sql script(.sql file) through VB

[sumit jakar]

how can a .sql file (containing script for creating tables etc.) be run in Sql Query Analyzer through VB.
The ultimate task is to create database in sql server 7.0 through VB.

thanks,
Sumit

[Karl]

You can use the osql utility, which is a command line utility. Although you are not using query analyzer it can still run the .sql file you talk about.

For example:

osql.exe /U username /P password /i c:...query.sql

There are other options you can use. Check out BOL for these.

Regards,

Karl




------------
sumit jakar at 12/4/00 7:02:07 AM

how can a .sql file (containing script for creating tables etc.) be run in Sql Query Analyzer through VB.
The ultimate task is to create database in sql server 7.0 through VB.

thanks,
Sumit