SQL Tip: Last Update Time

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 by