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