Here's a little script to tell you how many rows you have per table in a 2005 database.
Nothing fancy, but I found it useful.
declare @t table (partition_number int not null, name sysname not null, rows bigint not null)
from sys.partitions i
join sys.objects o on i.object_id=o.object_id
where o.type='U' and index_id IN (0, 1)
select * from
select null as partition_number, 'TOTAL' as name, sum(rows) as rows from @t
select * from @t
order by 1, 3 desc