>I have 28 CREATE TABLE scripts and 38 stored procedures all in seperate files. Is there a way in SQL 2005 to run all these together, so that I can recreate the database?
>
>Right now I have to open each script file and execute them one at a time.
>
>
>Thanks.

You can either copy them to a single file and run or programmatically create a loop that would execute each one (ie: SQLExec(m.handle, filetostr(aScript[m.ix])).

Cetin