Last modified datatime of a table! May 21, 2009 Select Object_name(object_id) as databasename,last_user_update from sys.dm_db_index_usage_stats where database_id=db_id('Foreclosure_24April') and object_id=object_id('tbl_fc_task') Read more