ManEx KB

Code that could be used to find Last Table Modified within SQL

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*

FROM sys.dm_db_index_usage_stats

ORDER BY sys.dm_db_index_usage_stats.last_user_update desc