Rowcount for All Tables

Sysindexes stores the table rowcounts based on statistical updates. While this query is not the most accurate, because statistical updates can be out of sync, it is definitely the quickest and least intrusive.

[cc lang=”sql”]
SELECT SUM(rowcnt)
FROM sysindexes
WHERE indid < 2
[/cc]