Good point, Jason. Thanks!

Instead of using dbo.sysindexes, sys.partitions can be used to obtain the rowcount

SELECT ( SCHEMA_NAME(o.schema_id) + '.' + OBJECT_NAME(o.object_id) ) AS TblName,

p.rows AS RowCnt

FROM sys.partitions AS p

INNER JOIN sys.objects AS o ON p.object_id = o.object_id

WHERE o.type_desc = 'USER_TABLE'

AND p.index_id IN ( 0, 1 )