SQL - Cantidad de registros por Tabla en BD

USE [mi_base_de_datos]
/*Cantidad de registros del Modelo*/
select substring(obj.name, 1, 50) as Tabla, ind.rows as Registros
from sysobjects as obj
inner join sysindexes as ind on obj.id = ind.id
where obj.xtype = 'u'
and ind.indid < 2
order by ind.rows desc