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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s