CREATE TABLE #tmp(

tablename   SYSNAME,

[rows] INT,

reserved NVARCHAR(200),

data   NVARCHAR(200),

index_size   NVARCHAR(200),

unused   NVARCHAR(200))

EXEC sp_MSForEachTable 'INSERT #tmp EXEC sp_spaceused ''?'''

SELECT #tmp.*

FROM #tmp

INNER JOIN sys.all_objects as ao

ON #tmp.tablename = ao.name

WHERE ao.schema_id = 1

ORDER by [rows] DESC