View all modified objects

 

SELECT  [name],type_desc  FROM sys.objects 
 WHERE  (type = ‘P’ or type=‘U’ or type=‘V’ ) AND DATEDIFF(D,modify_date, GETDATE()) < 7
ORDER  BY[name]  ASC 
Advertisements