spy the database sp changes

SELECT name, create_date, modify_date
FROM sys.objects

WHERE type = 'P'

order by modify_date desc