Relevamiento completo de bases de datos SQL Server

SELECT  @@SERVERNAME AS Server ,

        d.name AS DBName ,

              d.state_desc AS Status,

              suser_sname(owner_sid) AS Owner,

        --create_date AS 'Create date' ,

              recovery_model_Desc AS 'Recovery Model' ,

              collation_name AS Collation,

        compatibility_level AS 'Compatibility level',

        m.physical_name AS Path

FROM    sys.databases d

        JOIN sys.master_files m ON d.database_id = m.database_id

WHERE   m.[type] = 0 -- data files only

ORDER BY d.name;

GO