Get Content of store procedure

sp_helptext store_proc_name

http://www.powergui.org/thread.jspa?threadID=8042&tstart=0

or

select m.definition
from sys.objects o
join sys.sql_modules m
on o.object_id = m.object_id
join sys.schemas s
on s.schema_id = o.schema_id
where s.name = 'foo' -- Schema name
and o.name = 'bar' -- Sproc name

or

sys.sql_modules.