(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 ProcsWhich works perfectly when executed from SSMS.