指定数据库,然后:
select Name,Create_date,Modify_Date from sys.objects where type in ('U','P', 'V','F', 'TR', 'FN') order by Modify_Date desc