SQL 2005 scripts

I have many saved SQL scripts.  Is there a way to tell SQL look in this directory and run all the scripts in the directory one after the other?  If not, is there anything close to accomplishing the task of firing off dozens of scripts that are all saved as individual *.sql files?
dastaubAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jogosConnect With a Mentor Commented:
Sqlcmd utility
http://msdn.microsoft.com/en-us/library/ms170207.aspx

And then have a script that calls all scripts

:r script1.sql
:r script2.sql
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.