MS SQL - script stored procedures modiffied in the last n days

--modiffied sp

SELECT name

FROM sys.objects

WHERE type = 'P'

AND DATEDIFF(D,modify_date, GETDATE())

---------------------------

--modiffied sp, tables, views:

SELECT name, type_desc

FROM sys.objects

WHERE (type = 'P' or type='U' or type='V')

AND DATEDIFF(D,modify_date, GETDATE())

order by name asc