T-SQL - SP gemme resultatet i en tabel

Hej
Du kan evt. køre denne for første info:
declare @dbname sysname 
declare @dbsize dec(15,0) 
declare @logsize dec(15)
select @dbsize =  sum(convert(dec(15),size)) 
  from dbo.sysfiles 
  where (status & 64 = 0) 
 
select  @logsize = sum(convert(dec(15),size)) 
  from dbo.sysfiles 
  where (status & 64 <> 0) 

declare @bytesperpage dec(15,0) 
declare @pagesperMB  dec(15,0) 
 
select @bytesperpage = low 
  from master.dbo.spt_values 
  where number = 1 
  and type = 'E' 
select @pagesperMB = 1048576 / @bytesperpage 
 
select  database_name = db_name(), 
  database_size = 
  ltrim(str((@dbsize + @logsize) / @pagesperMB,15,2) + ' MB'), 
  'unallocated space' = 
  ltrim(str((@dbsize - 
    (select sum(convert(dec(15),reserved)) 
    from sysindexes 
      where indid in (0, 1, 255) 
    )) / @pagesperMB,15,2)+ ' MB') 
 
og den næste for

create table #spt_space 
( 
rows  int null, 
reserved dec(15) null, 
data  dec(15) null, 
indexp  dec(15) null, 
unused  dec(15) null 
) 


declare @pages int

insert into #spt_space (reserved) 
  select sum(convert(dec(15),reserved)) 
  from sysindexes 
    where indid in (0, 1, 255) 
 
/* 
** data: sum(dpages) where indid < 2 
** + sum(used) where indid = 255 (text) 
*/ 
select @pages = sum(convert(dec(15),dpages)) 
  from sysindexes 
    where indid < 2 
select @pages = @pages + isnull(sum(convert(dec(15),used)), 0) 
  from sysindexes 
  where indid = 255 
update #spt_space 
  set data = @pages 
 
 
/* index: sum(used) where indid in (0, 1, 255) - data */ 
update #spt_space 
  set indexp = (select sum(convert(dec(15),used)) 
    from sysindexes 
    where indid in (0, 1, 255)) 
      - data 
 
/* unused: sum(reserved) - sum(used) where indid in (0, 1, 255) */ 
update #spt_space 
  set unused = reserved 
    - (select sum(convert(dec(15),used)) 
    from sysindexes 
      where indid in (0, 1, 255)) 
 
select reserved = ltrim(str(reserved * d.low / 1024.,15,0) + 
    ' ' + 'KB'), 
  data = ltrim(str(data * d.low / 1024.,15,0) + 
    ' ' + 'KB'), 
  index_size = ltrim(str(indexp * d.low / 1024.,15,0) + 
    ' ' + 'KB'), 
  unused = ltrim(str(unused * d.low / 1024.,15,0) + 
    ' ' + 'KB') 
  from #spt_space, master.dbo.spt_values d 
  where d.number = 1 
  and d.type = 'E'

Kan du bruge det?