How many rows are in each table?

select object_name(id) table_name, rows
from sys.sysindexes
where xmaxlen in ('89', '92')
--and object_name(id) = 'sometablename'
order by rows --desc
--order by table_name desc