Findout the recently modified objects in sql database

SELECT name, create_date, modify_date

FROM sys.objects

WHERE type = 'P'

order by modify_date desc