ScottPletcher (11/25/2013)
Use view "sys.dm_db_index_operational_stats".Capture the values at the start time, then recapture them at any subsequent time, subtract the two values, and voila, you have the mods that occurred during that time.
doh! i knew about that view too, used it before for last accessed data;
i should have remembered, great job Scott.
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!