Questa è una vecchia versione del documento!

Query Db User
(Elenca tutti i DB di un'istanza SQL Server)

SELECT
    db.database_id ID,
    db.name DBName,
	mf.name LogicalName,
    mf.type_desc FileType,
    mf.Physical_Name Path,
	mf.size Size,
	db.collation_name Collation,
	db.recovery_model_desc RecMode
FROM
    sys.master_files mf
INNER JOIN 
    master.sys.databases db ON db.database_id = mf.database_id
WHERE db.database_id > 4
	ORDER BY DBName, FileType