>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.

Can't you just copy them all into one file and run them that way?