解决方法
从这里：
http://sqlserver2000.databases.aspfaq.com/how-do-i-get-a-list-of-sql-server-tables-and-their-row-counts.html
SELECT
[TableName] = so.name,[RowCount] = MAX(si.rows)
FROM
sysobjects so,sysindexes si
WHERE
so.xtype = 'U'
AND
si.id = OBJECT_ID(so.name)
GROUP BY
so.name
ORDER BY
2 DESC