Xrhrft

This page is only for reference, If you need detailed information, please check here

0 I use sys.dm_db_index_usage_stats.last_user_seek , sys.dm_db_index_usage_stats.last_user_scan and sys.dm_db_index_usage_stats.last_user_lookup to query last time a table was read. For views, functions and stored procedures I'm using sys.objects but it doesn't have any field for read datetime. Is there any system table where I can see the last time these types of objects were read/used? My objective is to find objects that aren't being used and possibly drop them. sql-server sql-server-2012 share | improve this question asked Aug 15 '16 at 15:02 Hikari Hikari 570 3 18