Hi there,

I'm just trying to find out which is the best way to programmaticall y run an sql script. In our system we have a mechanism of creating a new database for any new clients. We have scripted all of the tables/stored procedures/indexes etc into an SQL file.

Once we have created a new database, we need to be able to run our script against that database so that all of the database objects are created automatically....