Check if table had been touched
List all tables that had been touched. Even select statement are touched.
Last updated:
Warning: Review and test in a non-production environment before running.
select t.name,user_seeks,user_scans,user_lookups,user_updates,last_user_seek,last_user_scan,last_user_lookup,last_user_update
from sys.dm_db_index_usage_stats i JOIN sys.tables t on(t.object_id = i.object_id) where database_id = db_id();