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?