I needed to get a list of all of the Stored Proceduresin a database. This is the script that I used:
select ROUTINE_NAME as [Name], LAST_ALTERED as [Date Modified], ROUTINE_DEFINITION as Script
from information_schema.routines
where routine_type = 'PROCEDURE'