Good little query to find modified dates of SQL Server stored procedures.
The following example will find stored procs that have been modified in the last 7 days.
SELECT name, modify_date
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 7
ORDER BY modify_date desc
