number_of_rows_per_table.sql

-- SQL Server

SELECT  [Tables] = so.name,
        [Rows] = 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