Find last N days created Stored procedures
Use the below code which is shown what are the stored procedure createdin last 'N' days
SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 7
Note: Change 7 to any other day value
 |
| List All Stored Procedure Created in Last N Days |
Find last N days modified Stored procedures
SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 7
Note: Change 7 to any other day value
 |
| List All Stored Procedure Modified in Last N Days |
