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:
Related posts