Row Count Per Table

SELECT t.name TableName, i.rows Records
FROM sysobjects t, sysindexes i
WHERE t.xtype = 'U' AND i.id = t.id AND i.indid in (0,1)
ORDER BY Records DESC;