Articles in categories

Articles

Search recently created or modified Stored Procedures

Search for recently modified Stored Procedures

SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 5 -- modified last 5 days

 

Search for recently created Stored Procedures

SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 5 -- created in the last 5 days