>for the reccount in all tables of a database, I use that view:
>
>

>CREATE VIEW [dbo].[v_reccount]  AS 
>SELECT        o.name                 AS NomTable ,
>              ddps.row_count         AS Reccount
>       FROM   sys.indexes            AS i
>              INNER JOIN sys.objects AS o
>              ON     i.object_id = o.object_id
>              INNER JOIN sys.dm_db_partition_stats AS ddps
>              ON     i.object_id = ddps.object_id
>                 AND i.index_id  = ddps.index_id
>       WHERE (
>                     i.index_id < 2
>              )
>          AND (
>                     o.is_ms_shipped = 0
>              )
>
>

>
>It relies on statistics, so you need to set the stats auto

Thanks