2008得到当前实例的所有数据库的容量

CREATE TABLE #helpdb(
 [name] [nvarchar](128) NOT NULL,
 [db_size] [nvarchar](13) NULL,
 [owner] [nvarchar](128) NULL,
 [dbid] [smallint] NULL,
 [created] [nvarchar](11) NULL,
 [status] [nvarchar](600) NULL,
 [compatibility_level] [tinyint] NULL
) ON [PRIMARY]
insert into #helpdb EXEC sp_helpdb
select sum(cast(REPLACE(db_size,'MB','') as float)) as dbsize from #helpdb

drop table #helpdb