Hi,

I want to calculate the percentage of free space in my datafiles.
But the problem is, how?!

I know how to calculate the size and maxsize from the sysfiles, therefore I used these queries.

select sum(maxsize) from dbo.sysfiles
select sum(size) from dbo.sysfiles

Can anybody help me out??