MSSQL2005 获取所有表的记录数

1 SELECT B.NAME, A.ROWCNT FROM SYSINDEXES AS A
2  LEFT JOIN SYS.OBJECTS AS B ON A.ID = B.OBJECT_ID
3 WHERE B.TYPE = 'U' AND A.KEYCNT < 1
4 ORDER BY A.ROWCNT DESC