Wednesday, July 15, 2009

SQL: Check the last table update

 
 

select

db_name(database_id),

object_name(object_id),

last_user_update,

* from

sys.dm_db_index_usage_stats

where

object_id in

(

OBJECT_ID(N'Databasename.owner.TableName1'),

OBJECT_ID(N'Databasename. owner. TableName2')

)

order by dm_db_index_usage_stats.last_user_update desc