THis is also useful. Shows not only sprocs

SELECT DISTINCT

name

,type

,type_desc

,create_date

,modify_date

FROM

sys.objects

WHERE

type IN ('P','PK','F','D','FN','TR','UQ','X')

ORDER BY

type

,modify_date DESC