Below is the best in sql2005

SELECT object_name(object_id) 'Table_Name', SUM(row_count) 'Total_Rows'

FROM sys.dm_db_partition_stats where index_id <2 GROUP BY object_name(object_id)

ORDER BY object_name(object_id)