Below is code that could be used to find Last Table modified within manexSQL:
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
Modified on: Wed, 29 Jun, 2022 at 3:33 PM
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
Did you find it helpful? Yes No
Send feedback