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