Create multiple stored procedures

SS2000

What is the most efficient way to create numerous (about 100) stored procedures from individual .sql code files?  I really don't want to deal with them individually.  Is there some way to quickly concantenate them into one file?

Thanks
tguillor
tguillorAsked:
Who is Participating?
 
LowfatspreadConnect With a Mentor Commented:
do use want to use the dos for command to just invoke the osql utility to compile your procedures?

eg in DOS

FOR %a IN (*.SQL) DO ECHO OSQL -I%a -O%a.OUT -E -SSERVERNAME -DDATABASENAME >> A.bat

then

a.bat ...

assuming you use a trusted connection -E

hth
0
 
YZlatCommented:
you could put all the file names into an array.
Then loop through the array, retrieving file names.
The open each file and run the code
0
 
Eugene ZCommented:
open query analyzer and open the .sql  and run
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.