Space Used By Table

CREATE TABLE #space ( tableName sysname,
 numrows integer,
 reserved varchar(25),
 data varchar(25),
 indexsize varchar(25),
 unused varchar(25))

declare objcurs cursor for select [name] from sys.objects where type = 'U'
declare @name sysname
open objcurs
fetch next from objcurs into @name
while @@fetch_status = 0
begin
 insert into #space
 exec sp_spaceused @name
 fetch next from objcurs into @name
end
close objcurs
deallocate objcurs

select * from #space order by 
convert(integer, replace(data,'KB','')) desc