I prefer to use system objects that aren't marked for removal from a future release of SQL Server, I prefer not to use undocumented stored procs, and I prefer accuracy in my results:

SELECTQUOTENAME(OBJECT_SCHEMA_NAME(ps.object_id))

+ '.' + QUOTENAME(OBJECT_NAME(ps.object_id)) AS TableName,

SUM(ps.row_count) AS row_count

FROM sys.dm_db_partition_stats ps

WHERE ps.index_id <= 1

AND OBJECTPROPERTY(ps.object_id, 'IsMSShipped') = 0

GROUP BY ps.object_id

ORDER BY TableName

Chris