J Wolfgang Goerlich's thoughts on Information Security
SQL Tip: Last Update Time

By wolfgang. 17 May 2008 06:18

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'');

Tags:

    Log in