Ever wondered to see all the tables names and the last time they were updated? This is a query which will give you all the desired result. Select Distinct Object_name(object_id) as DatabaseName, Object_id, Database_id, Last_user_update From Sys.dm_db_index_usage_stats Where database_id = db_id() and last_user_update is not null