SQL Server table size

Our BI environment is growing at a rapid rate.  I was looking for a script to give me the size of all the tables.  I found a good one here ( http://devio.wordpress.com/2007/10/11/how-much-space-do-my-sql-server-tables-use/).  A copy of the script is posted below.



create table #t
(
  name nvarchar(128),
  rows varchar(50),
  reserved varchar(50),
  data varchar(50),
  index_size varchar(50),
  unused varchar(50)
)

declare @id nvarchar(128)
declare c cursor for
select name from sysobjects where xtype='U'

open c
fetch c into @id

while @@fetch_status = 0 begin

  insert into #t
  exec sp_spaceused @id

  fetch c into @id
end

close c
deallocate c

select * from #t
order by convert(int, substring(data, 1, len(data)-3)) desc

drop table #t