Whenever I am researching stored procs, I try to remember the following queries:
Search within a stored proc. Useful when trying to understand what stored procs refer to another stored proc.
select * from syscomments where text like '%KeyWords%'
Show the entire stored proc. Copy and paste the results to screen and alter.
sp_helptext StoredProcedureName
