Drop all formatter extended props from the stored procedures of sql server 2005

USE mydb
GO
alter proc procUtils_DeleteProcsExtProps
as
begin
--use poc
--go
DECLARE @procName varchar(100)
DECLARE @cursorProcNames CURSOR
SET @cursorProcNames = CURSOR FOR
select s.name from sysobjects s where type = 'P' AND S.NAME NOT LIKE '%sp_alterdiagram' and s.name not like '%sp_alterdiagram' and s.name not like '%sp_renamediagram' and s.name not like '%sp_dropdiagram' and s.name not like '%sp_helpdiagrams' and s.name

not like '%sp_creatediagram' and s.name not like '%sp_upgraddiagrams' and s.name not like '%sp_helpdiagramdefinition%'

OPEN @cursorProcNames
FETCH NEXT
FROM @cursorProcNames INTO @procName
WHILE @@FETCH_STATUS = 0
BEGIN

set nocount off;
-- exec sp_HelpText @procName --- or print them
-- print @procName

print 'EXEC sys.sp_dropextendedproperty @name=N''Col0NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col1NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col2NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col3NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col4NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col5NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col6NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col7NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col8NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col9NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col10NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col11NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col12NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col13NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col14NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col15NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col16NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col17NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col18NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col19NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''
print 'EXEC sys.sp_dropextendedproperty @name=N''Col20NumberFormat'', @level0type=N''SCHEMA'',@level0name=N''dbo'', @level1type=N''PROCEDURE'',@level1name=N''' + @procName + ''''




FETCH NEXT
FROM @cursorProcNames INTO @procName
END
CLOSE @cursorProcNames
end


/*


USAGE:

EXEC procUtils_DeleteProcsExtProps
GO


*/