<div>
this will do it: 
 

<pre><code class="code-10 nolinks" id="code-122411">use master
go
 
create proc sp_dbsize
as
 
declare @dbsize bigint, 
@logsize bigint, 
@reservedpages INT, 
@usedpages INT, 
@pages INT
	
select @dbsize = sum(convert(bigint,case when status &amp; 64 = 0 then size else 0 end))
		, @logsize = sum(convert(bigint,case when status &amp; 64 &lt;&gt; 0 then size else 0 end))
		from dbo.sysfiles
 
	select @reservedpages = sum(a.total_pages),
		@usedpages = sum(a.used_pages),
		@pages = sum(
				CASE
					-- XML-Index and FT-Index-Docid is not considered &quot;data&quot;, but is part of &quot;index_size&quot;
					When it.internal_type IN (202,204) Then 0
					When a.type &lt;&gt; 1 Then a.used_pages
					When p.index_id &lt; 2 Then a.data_pages
					Else 0
				END
			)
	from sys.partitions p join sys.allocation_units a on p.partition_id = a.container_id
		left join sys.internal_tables it on p.object_id = it.object_id
 
	/* unallocated space could not be negative */
	select 
		database_name = db_name(),
		database_size = ltrim(str((convert (dec (15,2),@dbsize) + convert (dec (15,2),@logsize)) 
			* 8192 / 1048576,15,2) + ' MB'),
		'unallocated space' = ltrim(str((case when @dbsize &gt;= @reservedpages then
			(convert (dec (15,2),@dbsize) - convert (dec (15,2),@reservedpages)) 
			* 8192 / 1048576 else 0 end),15,2) + ' MB'), 
		reserved = ltrim(str(@reservedpages * 8192 / 1024.,15,0) + ' KB'),
		data = ltrim(str(@pages * 8192 / 1024.,15,0) + ' KB'),
		index_size = ltrim(str((@usedpages - @pages) * 8192 / 1024.,15,0) + ' KB'),
		unused = ltrim(str((@reservedpages - @usedpages) * 8192 / 1024.,15,0) + ' KB')
 
 
go
exec sp_ms_marksystemobject 'sp_dbsize'
 
 
create table #spaceused(dbname nvarchar(255), dbsize varchar(100), unalloc varchar(100), 
reserved varchar(100), data varchar(100), index_size varchar(100), unused varchar(100))
 
insert into #spaceused
exec sp_msforeachdb 'use ? exec sp_dbsize' 
 
select * from #spaceused
</code></pre>
</div>

<div>
Thanks this worked. &nbsp;I have linked four db servers together. &nbsp;How could I use this sp to display the other databases on the other servers? Create this store proccedure on each server then execute from one location: 
exec DB01.master.dbo.sp1 
exec DB02.master.dbo.sp2 
 
etc. 
 
I am trying to build a comprehensive report that can accessed via a dashboard app on the controlling server.
</div>

<div>
<div class="content wysiwyg-content">
I need to create a stored procedure that will cycle through a series of databases on multiple servers so ican calculate the actual db sizes. I wouldlike to use the valuses created by sp_spaceused.
</div>
</div>

I need to create a stored procedure that will cycle through a series of databases on multiple servers so ican calculate the actual db sizes. I wouldlike to use the valuses created by sp_spaceused.

Using T-SQl to get actual DB sizes in SQL 2005 based on the sp_spaceused stiored procedure

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.