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