SQL SERVER获取数据库文件信息

MS SQL SERVER 获取当前数据库文件等信息，适用于多个版本：

SELECT dbf.file_id AS FileID

    , dbf.name AS [FileName]

    , s.filename AS FileLocation

    , CAST(dbf.size/128.0 AS DECIMAL(19,2)) AS FileSizeMB

    , CAST(CAST(FILEPROPERTY(dbf.name, 'SpaceUsed') AS int)/128.0 AS DECIMAL(19,2)) AS SpaceUsedMB

    , CAST(dbf.size/128.0 - CAST(FILEPROPERTY(dbf.name, 'SpaceUsed') AS int)/128.0 AS DECIMAL(19,2)) AS AvailableSpaceMB

    , CAST((dbf.size / 128.0 - (FILEPROPERTY(dbf.name, 'SpaceUsed') / 128.0)) / (dbf.size / 128.0) * 100 AS DECIMAL(19,2)) AS [%FreeSpace]

    , dbf.growth / 128 AS FileGrowthMB

    , f.name AS FilegroupName

FROM sys.database_files dbf

    INNER JOIN sys.sysfiles s ON dbf.name = s.name

    LEFT JOIN sys.filegroups f ON dbf.data_space_id = f.data_space_id

ORDER BY dbf.name;

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }