mass compile in sql server 1

[misterstick]

further to thread183-1532457

i have multiple stored procedures.

the code for each is in a separate t-sql script file.

a change of server has changed the way that dates are handled.

http://www.google.com/search?hl=en&...sulted+in+an+out-of-range+smalldatetime+value

to stop this happening again, i've changed the code as needs it, eleven files.

i'm on day four of my journey into sql server, and eleven is probably going to become hundreds.

how can i run the scripts to recompile the all stored procedures without having to do it one at a time?

many thanks,

mr s. <

 

[misterstick]

the answer is to use the command line utility sqlcmd, issuing the command :r script.

now, where's my sockpuppet to give myself a star.

mr s. <

 

[SimonSellick]

Thanks for posting the answer as well as the question. To run a number of scripts, do you give sqlcmd a script containing the script filenames, or do you run a DOS batch file / Windows command script calling sqlcmd for each one?