SQL Server: Find modified Stored Procedures with Dates

Good little query to find modified dates of SQL Server stored procedures.
The following example will find stored procs that have been modified in the last 7 days.

SELECT name, modify_date
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 7 ORDER BY modify_date desc

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.