there is "sp_spaceused" for one db at a time. For a quick, approximation of all DBs, I use this sometimes:--List the approximate size of all databases on serverset nocount onif object_id('tempdb..#temp') > 0 drop table #tempcreate table #temp (db sysname, size int)declare @dbid int ,@sql varchar(2000)select @dbid = min(dbid) from master..sysdatabaseswhile @dbid is not nullbegin set @sql = 'select ''' + db_name(@dbid) + ''', sum(size) from ' + db_name(@dbid) + '..sysfiles' insert #temp(db, size) exec (@sql) select @dbid = min(dbid) from master..sysdatabases where dbid > @dbidend--size column in sysfiles is in 8 KB pagesselect ((size*8)/1024)/1024.0 [GB], db from #temp order by size desc
Be One with the OptimizerTG