select * from
(
	select [name],create_date,modify_date, 'sp' as ObjType from sys.procedures
	union all
	select [name],create_date,modify_date, 'table' as ObjType from sys.tables
	union all
	select [name],create_date,modify_date, 'view' as ObjType from sys.views
) sub
order by modify_date desc