Create view dbo.vsa_db_SpaceAllocate
as
select    
    sa.dbid, db_name(sa.dbid) as dbname, sa.name as SegmentName,
    CONVERT(DECIMAL(38,0), Convert(decimal(38,0), sa.Total_Pages) * /*@@maxpagesize*/2048/1024/1024,0) as TotalMb, 
    CONVERT(DECIMAL(38,0), Convert(decimal(38,0), sa.Free_Pages) * /*@@maxpagesize*/2048/1024/1024) as FreeMb,
    CONVERT(DECIMAL(38,0), Convert(decimal(38,0),
        Case 
            when sa.segbit = 4 and sd.status2 & 32768 = 32768 then IsNull(lct_admin("num_logpages", sa.dbid),0) + sa.Total_Pages / 256
            when sa.segbit = 4 and sd.status2 & 32768 <> 32768 then sa.Total_Pages - sa.Free_Pages - lct_admin("reserved_for_rollbacks", sa.dbid)
            else sa.Total_Pages - sa.Free_Pages
        end) * /*@@maxpagesize*/2048/1024/1024) as UsedMb,
    CONVERT(DECIMAL(38,0), Convert(decimal(38,0),
        Case 
            when sa.segbit = 4 then lct_admin("reserved_for_rollbacks", sa.dbid)
            else 0
        end) * /*@@maxpagesize*/2048/1024/1024) as ReservedMb
from
(
    Select
      su.dbid, si.name, si.segbit, sum(IsNull(su.size,0)) as Total_Pages,
      case 
        when segbit = 4 then
            lct_admin("logsegment_freepages", su.dbid) - lct_admin("reserved_for_rollbacks", su.dbid)
        else sum(curunreservedpgs(su.dbid, su.lstart, su.unreservedpgs))
      end as Free_Pages
    from 
    (
      Select 
        ss.name, 
        Case 
          when ss.segment < 31 then power(2, ss.segment)
          else sv.low 
        end as segbit,
        convert(float, sv.low) / 1048576.0 as factor
      from syssegments ss, master.dbo.spt_values sv,master.dbo.spt_values svFactor
        where sv.type ='E' and sv.number = 2 and svFactor.type = 'E' and svFactor.number = 1 
    ) si
    join master.dbo.sysusages su on 1=1
    where su.segmap & si.segbit = si.segbit
	  --and su.dbid = db_id()
    group by su.dbid, si.name,si.segbit
) sa
  join master.dbo.sysdatabases sd on sd.dbid = sa.dbid