- SELECT OBJECT_NAME(object_id) AS table_name,
- last_user_seek,
- last_user_scan,
- last_user_lookup,
- last_user_update,
- last_system_seek,
- last_system_scan,
- last_system_lookup,
- last_system_update
- FROM sys.dm_db_index_usage_stats
- WHERE database_id = DB_ID('dataname')
- GO