显示具有大小和增长信息的所有数据库的所有数据文件
SELECT d.nameAS 'Database', d.database_id, SF.fileid, SF.nameAS 'LogicalFileName', CASESF.status& 0x100000 WHEN 1048576 THEN 'Percentage' WHEN 0 THEN 'MB' END AS 'FileGrowthOption', Growth AS GrowthUnit, ROUND(((CAST(Size AS FLOAT)*8)/1024)/1024,2) [SizeGB], -- Convert 8k pages to GB Maxsize, filename AS PhysicalFileName FROM Master.SYS.SYSALTFILES SF Join Master.SYS.Databases d onsf.fileid= d.database_id Order by d.name