How to check date of last change in stored procedure or function in SQL server

The Solution to How to check date of last change in stored procedure or function in SQL server is


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.

~ Answered on 2011-04-07 10:00:17


Most Viewed Questions: