SQL Server - File Sizes

fileSizes.sql

;WITH files AS (
    select name
         , filename
         , size
         , fileproperty ( name, 'SpaceUsed' ) as used
      from sysfiles
)
select name
     , filename
     , convert ( decimal ( 12, 2 ), size / 128.000 )            as FileSizeMB
     , convert ( decimal ( 12, 2 ), used / 128.000 )            as UsedMB
     , convert ( decimal ( 12, 2 ), ( size - used ) / 128.000 ) as FreeMB
  from files