>What I was hoping for was an easy way to set output to file in the script. This is a one time thing where I need to remove about 600 SPs from a DB (long story). My source script creates such a script that I can edit to preserve the 6 SPs in that DB that are still used. My generated script also checks for existance before the DROP...
You can output the result to a file from SMSS. In the Query menu select Results to File.
If it's not broken, fix it until it is.
My Blog