Get List of Stored Procedures Modified in last n days

25 Mar

In this post we will learn how to get list of stored procedures modified in last n days.

Query

SELECT * FROM sys.objects
WHERE TYPE = 'P' AND DATEDIFF(D, modify_date, GETDATE()) < 7

Leave a Reply

Your email address will not be published. Required fields are marked *