Today, I needed a quick view of what objects in a SQL DB had changed. The following get's me that in a nice list:
SELECT [name], [type], create_date, modify_dateFROM sys.objectsWHERE [type] in ('P', 'FN', 'V') order by Modify_Date desc
SELECT [name], [type], create_date, modify_dateFROM sys.objectsWHERE [type] in ('P', 'FN', 'V')
order by Modify_Date desc