Home Forums SQL Server 2005 Administering How to know what time a table is last-updated? RE: How to know what time a table is last-updated?
gmby
SSCarpal Tunnel
Points: 4511
More actions
February 2, 2010 at 9:23 am
#1112360
sys.dm_db_index_usage_stats does report on heaps, so it would include tables without indexes (index_id=0). But as mstjean mentions, the stats are only kept since the last server startup.
jg