SQL Tip: Last Update Time How do you get the time a table was last updated? SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID( ‘MyDBname”) AND OBJECT_ID=OBJECT_ID(‘MyTableName”); Posted May 17, 2008 by Wolf Goerlich