解决方法
从这里:
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