SQLTeam.com | Weblogs | Forums

How do I find out when a table was last used not using sys.dm_db_index_usage_stats


#1

I have been trying to find out when tables were last used. Unfortunately I cannot use the system table sys.dm_db_index_usage_stats as the last_user_scan is changed when you add a filter on the tables in SSMS and the tables found fit the criteria. Very odd but that's what happens.

Is there any other way?