Einar

Below is a stored procedure I use to get the free space of the drives, and you can use sp_helpfile to get the current size of files.

CREATE PROCEDURE dbo.Get_DriveDiskDriveData

as

create table #FreeSpace( cDrive char(1),  MB_Free int)

insert into #FreeSpace exec master..xp_fixeddrives 

select * from #freespace
drop table #freespace
GO