SQL Server Performance Forum – Threads Archive
Tables Information
Anybody that has script from DMVs (if possible) that gives when information when table is last accessed.I believe you can get this information from sys.dm_db_index_operational_stats DMV… You can use the script from the following article… http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
]]>