Query to return the number of rows for each table in the database.
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
ORDER BY TblRowCount DESC, TableName ASC