what to return size of Database in a query

[Derrick McNeill]

I'm trying to retrieve information on each server that would tell me what
databases I have on each server and the size of each database the path of
the files and the sizes I want to put this all in one query can someone please
help me out. Thanks Derrick


Select name,dbid,crdate,filename,version
from SQL1.master.dbo.sysdatabases
union all
Select name,dbid,crdate,filename,version
from DW1.master.dbo.sysdatabases
union all
Select name,dbid,crdate,filename,version
from Sql2.master.dbo.sysdatabases