适用于SQL2005和SQL2008:
select specific_name,last_altered from information_schema.routines order by last_altered desc