Deploy multiple db scripts to multiple servers
After doing some code cleanup on some stored procedures, I needed a efficient way to deploy the scripts to multiple servers/databases. I had 20 different scripts and though that is not a huge amount I still wasn't looking forward to opening each file in Query Analyzer and executing for each server. Google saves the day again and led me to a DOS command that fit the bill perfectly. (Note that if you run the command from within a .bat file you should specify %%variable instead of %variable)
