-------- Get all stored procedure scripts ---- scripts

Declare @ proc_text varchar (max)
Declare get_proc_text_cursor cursor
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