This group of similar queries return the object name, creation date and last modified date of various objects in the database.
-- Tables
SELECT name, create_date, modify_date
FROM sys.tables
ORDER BY modify_date DESC;
-- Procs
SELECT name, create_date, modify_date
FROM sys.procedures
ORDER BY modify_date DESC;
-- Views
SELECT name, create_date, modify_date
FROM sys.views
ORDER BY modify_date DESC;
-- Functions
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'FN'
ORDER BY modify_date DESC;