Did you check <a href="http://msdn.microsoft.com/en-us/library/ms176007.aspx">Microsoft documentation</a>? I remember that there was a sp that listed all basic information on the stored procedure but can't remind it right away. You can get a list of stored procedures by querying the sys.procedures catalog view. You can use the sp_helptext procedure to get the contents of each procedure.

Did you check <a href="http://msdn.microsoft.com/en-us/library/ms176007.aspx">Microsoft documentation</a>? I remember that there was a sp that listed all basic information on the stored procedure but can't remind it right away. You can get a list of stored procedures by querying the sys.procedures catalog view. You can use the sp_helptext procedure to get the contents of each procedure.