从这个表sys.dm_db_index_usage_stats可以获取到所有表或某一张表的用户或系统异动时间：
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