The same can be done using sp_msforeachtable

See below script

---------------------------------------------------------------------

Create table #tmptblsize

(table_name varchar(50),

rows int,

reserved varchar(50),

actualdatasize varchar(50),

indexsize varchar(50),

unused varchar(50))

EXEC sp_MSforeachtable 'insert into #tmptblsize exec sp_spaceused ''?'''

select * from #tmptblsize

drop table #tmptblsize

--------------------------------------------------------------------

Chandu