declare @pagekb int
select @pagekb = low/1024
from master..spt_values
where number = 1
and type = 'E'
select user_name(o.uid) as 'owner',
o.name as 'table name',
i.indid,
case when i.indid in (0,1)
then data_pages(db_id(),o.id,0)
else data_pages(db_id(),o.id,i.indid)
end * @pagekb as 'used (KB)',
case when i.indid in (0,1)
then reserved_pages(db_id(),o.id,0)
else reserved_pages(db_id(),o.id,i.indid)
end * @pagekb as 'resvd (KB)'
from sysindexes i,
sysobjects o
where o.type = 'U'
and o.id = i.id
order by 2,1,3