I've a list of .sql script files to create Stored Procedures. Currently to
create all these Stored Procedures in another machine, I've to open & run
one-by-one from the Query Analzyer. This becomes tedious when the no. grows.
Is there a way to create a batch file that run the scripts, something like
this :

run script1.sql
run script2.sql
run script3.sql
...
run scriptn.sql

Thanks in advance,
Ben