Search This Blog

Friday, November 1, 2013

SQL Server script return the last stored procedures modified in the last n days

SQL Server > sys.objects > Last modified stored procedures

Example

declare @nmb_days int = 10
SELECT * FROM sys.objects 
WHERE TYPE = 'P' 
AND DATEDIFF(D,modify_date, GETDATE()) < @nmb_days