Find Stored Procedures Modified/Created in Last N Days
జులై 11, 2007
Stored Procedured modified for Last ‘N’ Days
SELECT name
FROM sys.objects
WHERE type = ‘P’
AND DATEDIFF(D,modify_date, GETDATE()) > N —(‘ N’ means number of days do you want ie.., 6, 7 etc )
Stored Procedured Create for Last ‘N’ Days
SELECT name
FROM sys.objects
WHERE type = ‘P’
AND DATEDIFF(D,create_date, GETDATE()) > N
