Lowell (10/5/2009)
ouch that sysindexes is handy and i haven't found any view that still tracks that [rows] and [rowmodctr] yet.
Rows are in sys.partitions, though you should aggregate by object and index in case there's a partitioned table.
There's no view that exposes the column mod counters (modifications are tracked by column in SQL 2005, not just by table as they were in SQL 2000). I could tell you the system table, but since system tables can't be read without jumping through hoops, it won't help much. Besides, the system table is not documented and not very clear in what's what.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability