Try this script
USE NORTHWIND
SELECT sysindexes.rows, sysobjects.name
FROM sysusers, sysobjects, sysindexes
WHERE sysusers.uid = sysobjects.uid and sysindexes.id = sysobjects.id and sysobjects.name not like '#%'
and OBJECTPROPERTY(sysobjects.id, N'IsMSShipped') <> 1 and OBJECTPROPERTY(sysobjects.id, N'IsSystemTable') = 0
ORDER BY INDEXPROPERTY(sysindexes.id, sysindexes.name, N'IsStatistics')
It gives each table row count in a given database.
--Mahesh