>>Add SET NOCOUNT ON at the begining of the script. Did you want to output the result of this select as a text? Did you see my blog - it solves very similar problem.
>>
>
>In other words, use BCP like this
>
>bcp "here goes your script'" queryout "c:\SP_scripts.sql" -S MyInstance -T -t -w
>
>>>>Biggest gotcha is making sure you have permissions enabled on the folder where you are writing the file.
>>>>
>>>>HTH
>>>
>>>Thank you Charles. There must be other gotchas I don't quite have my brain wrapped around. I end up with a result file that contains:
>>>
>>>

>>>(0 rows affected)
>>>

>>>
>>>the source script is
>>>
>>>

>>>WITH Procs (ProcName) AS 
>>>(
>>>    SELECT 
>>>        name 
>>>    FROM sys.procedures 
>>>    WHERE [type] = 'P' 
>>>		AND is_ms_shipped = 0 
>>>		AND [name] LIKE 'spMT%'
>>>)
>>>SELECT 
>>>'IF EXISTS(
>>>	SELECT *
>>>	FROM sys.objects
>>>	WHERE object_id = OBJECT_ID(N''[dbo].[' + ProcName + ']'') 
>>>		AND TYPE IN (N''P'', N''PC''))
>>>DROP PROCEDURE [dbo].[' + ProcName + ']
>>>GO
>>>
>>>'
>>>FROM Procs
>>>

>>>
>>>Which works perfectly when executed from SSMS.
>>>I suspect the problem is with the formatting of my script.

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...