Execute multiple .sql files

[Phthora]

I am working in a SQL Server 7/2000 environment. I have written a slew of .sql files designed to create tables, indexes, views, triggers, and stored procedures, to essentially recreate the database.

My question is how I can write one executable to execute all those .sql files -- in other words, one file I can execute that will recreate the entire database using my .sql files.

Thank you.

 

[CasperTFG]

put all the Statements into 1 file.

We do this when creating a DB. All our tables are created in 1 File of about 95 SQL statements. We run it through the Query Analyzer. Craig, mailto:sander@cogeco.ca

"Procrastination is the art of keeping up with yesterday."

I hope my post was helpful!!!