Get record count for every table in a DB

SELECT o.name TableName,

i.rows TblRowCount

FROM sysobjects o

INNER JOIN sysindexes i

ON (o.id = i.id)

WHERE o.xtype = 'u'

AND i.indid < 2