List all SQL Tables and its record count

This code sample shows how to list all Tables and its data Rows count

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