Ok for small db's but this is lightning quick and avoids cursors/looping...
select o.name, i.rows
from sys.sysobjects o with (nolock)
join sys.sysindexes i with (nolock)
on o.id = i.id
where i.indid < 2
order by i.rows desc, o.name
http://msdn.microsoft.com/en-us/library/ms190283.aspx