Loading ...

SQL: List of stored procedures modified in last n Days | CodeAsp.Net

SQL: List of stored procedures modified in last n Days

4.82 
 /5
4.82 (1votes)

Below is the script to get list of stored procedures in last n days.

SELECT  [name]
FROM    sys.objects
WHERE   [type] = 'P'
        AND DATEDIFF(dd, [modify_date], GETDATE()) < 10

Above 10 is the number of days. You can change that value according to your need. Below is the output of my screen after running the above script on AdventureWorks DB:


Comments (no comments yet)

Top Posts