declare @proc_text varchar(max)
DECLARE get_proc_text_cursor CURSOR FOR
SELECT
'if object_id(N'''+ [name] +''') is not null drop proc ' + [name] + CHAR(10) + CHAR(13) + ' GO ' + CHAR(10) + CHAR(13) + definition + CHAR(10) + CHAR(13) +' GO'
FROM
sys.sql_modules
inner join
sysobjects
on
sys.sql_modules.object_id = sysobjects.id
and
type='p' OPEN get_proc_text_cursor

FETCH NEXT FROM get_proc_text_cursor INTO @proc_text

WHILE @@FETCH_STATUS = 0

BEGIN
print @proc_text

FETCH NEXT FROM get_proc_text_cursor INTO @proc_text

END

CLOSE get_proc_text_cursor

DEALLOCATE get_proc_text_cursor