Store Procedure Utility

To view the definition of a stored procedure: 

sp_helptext procedure_name 

To view the information about a stored procedure: 

sp_help procedure_name 

To view the dependencies of the stored procedure: 

sp_depends procedure_name

To view list of all Procedures and Function

SP_STORED_PROCEDURES

Usefull link

http://www.quest-pipelines.com/newsletter-v3/0802_A.htm