select id,object_name(id) as tableName,indid,rows,rowcnt
from sys.sysindexes a where indid in(0,1)
order by rows desc
SELECT a.name, b.rows
FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id
WHERE (a.type = ‘u’) AND (b.indid IN (0, 1))
ORDER BY a.name,b.rows DESC
SELECT a.name, b.rows
FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id
WHERE (a.type = ‘V’) AND (b.indid IN (0, 1))
ORDER BY a.name,b.rows DESC