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.
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.