This script will return the objects in sql server database with modified and created date.
However you can change the order by clause as well as the Where clause according to your requirements
SELECT sys.schemas.name + '.' + sys.objects.name,
INNER JOIN sys.schemas ON sys.objects.schema_id = sys.schemas.schema_id
WHERE type = 'P'
OR type = 'U'
OR type = 'FN'
OR type = 'V'
ORDER BY modify_date DESC