SELECT object_name (i.id) TableName,
rows as RowCnt
FROM sysindexes i
INNER JOIN sysObjects o
ON (o.id = i.id AND o.xType = ‘U ‘)
WHERE indid < 2
ORDER BY RowCnt desc,TableName
查询所有表的记录数SQLServer,布布扣,bubuko.com
原文：http://www.cnblogs.com/weiryang/p/3842020.html