Questions
SELECT name, create_date, modify_date FROM sys.objects WHERE type = 'P' ORDER BY modify_date DESC
The type for a function is FN rather than P for procedure. Or you can filter on the name column.
type
FN
P
~ Answered on 2011-04-07 10:00:17