declare @id int
DECLARE @Percent_in_use numeric(18, 8)
select @id=(select max(data_space_id) from sys.database_files)
while @id<>0
begin
select D_F.[name],
D_F.physical_name,
D_F.size*8/1024 as ON_DISK_Mb,
sum(A_U.total_pages)*8/1024 as [ALL_Mb],
sum(A_U.used_pages)*8/1024 as IN_USE_Mb,
sum(A_U.data_pages)*8/1024 as DATA_Mb,
(D_F.size*8/1024-(sum(A_U.total_pages)*8/1024)) as FREE_Mb
from sys.allocation_units A_U
inner join sys.database_files D_F on D_F.data_space_id= A_U.data_space_id
and D_F.data_space_id= @id
group by D_F.[name],D_F.physical_name,D_F.size
set @id= @id - 1
end