CREATE TABLE #tempTable ( TableName VARCHAR(255) , RowCnt INT )
EXEC sp_MSforeachtable 'INSERT INTO #tempTable SELECT ''?'', COUNT(*) FROM ?'
SELECT TableName, RowCnt FROM #tempTable ORDER BY RowCnt desc
DROP TABLE #tempTable
EXEC sp_MSforeachtable 'INSERT INTO #tempTable SELECT ''?'', COUNT(*) FROM ?'
SELECT TableName, RowCnt FROM #tempTable ORDER BY RowCnt desc
DROP TABLE #tempTable