query, spaced using in database for each table

gistfile1.sql

SET NOCOUNT ON 

DBCC UPDATEUSAGE(0) 

-- DB size.
EXEC sp_spaceused

-- Table row counts and sizes.
CREATE TABLE #t 
( 
    [name] NVARCHAR(128),
    [rows] CHAR(11),
    reserved VARCHAR(18), 
    data VARCHAR(18), 
    index_size VARCHAR(18),
    unused VARCHAR(18)
) 

INSERT #t EXEC sp_msForEachTable 'EXEC sp_spaceused ''?''' 

SELECT
    [name],
    replace(convert(varchar,cast([rows] as money),1),'.00','') AS [rows],
    replace(convert(varchar,cast(replace(reserved,' KB','') as money),1),'.00','') AS reserved,
    replace(convert(varchar,cast(replace(data,' KB','') as money),1),'.00','') AS data,
    replace(convert(varchar,cast(replace(index_size,' KB','') as money),1),'.00','') AS index_size,
    replace(convert(varchar,cast(replace(unused,' KB','') as money),1),'.00','') AS unused
FROM   #t
order by [name]

-- # of rows.
SELECT replace(convert(varchar,cast(SUM(CAST([rows] AS int)) as money),1),'.00','') AS [rows]
FROM   #t
 
DROP TABLE #t