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)
insert @t
select
i.partition_number
,o.name
,i.rows
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
union all
select * from @t
) a
order by 1, 3 desc
elsasoft.org
How many rows per table?
Posted - 02/25/2008 : 17:04:44
