In some cases we may want to get from MSSQL list all SPs by its modified date so that we know what we or our college did modified last. Here is a query you may use
SELECT name, OBJECT_DEFINITION(object_id), modify_date
ORDER BY modify_date DESC
This query will return the SPs from the latest modified stored procedure. Its handy specially when your migrating SPs manually.