declare @proc_name varchar(100)
declare @str_query nvarchar(MAX)

declare loop_proc cursor 
for select [name] from sys.procedures where type='P' 
and is_ms_shipped = 0
open loop_proc

FETCH NEXT FROM loop_proc INTO @proc_name
IF @@FETCH_STATUS <> 0 
PRINT ' <>' 
WHILE @@FETCH_STATUS = 0 

BEGIN 
SELECT @str_query = 'sp_helptext ' + @proc_name 
PRINT @str_query 
exec sp_executesql @str_query 
FETCH NEXT FROM loop_proc INTO @proc_name 
END
CLOSE loop_proc
DEALLOCATE loop_proc