CREATE
TABLE #temp (
[table_name] NVARCHAR(128),
[rows] CHAR(11),
reserved VARCHAR(18),
data VARCHAR(18),
index_size VARCHAR(18),
unused VARCHAR(18))
INSERT #temp EXEC sp_msForEachTable 'EXEC sp_spaceused ''?'''