USE [testdb] GO SELECT name AS [File Name], physical_name AS [Physical Name], size / 128.0 AS [Total Size in MB], size / 128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int) / 128.0 AS [Available ...