Below query gives you the list of stored procedures which got changed in last
7 days....
SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 7
Note : You can change the
7 number in the WHERE condition with
N -- here N represents the number of days