PROCEDURES_FREE_SPACE.SQL

CREATE PROCEDURE getFreeSpaceDrive
	@drive varchar(1),
	@MB_Free INT OUTPUT
AS
BEGIN
	/*
	* PROCEDURE FOR GETTING FREE SPACE IN A DRIVE @drive
	* RETURN @MB_Free
	* FOR TESTING PROCEDURE EXECUTE THESE LINES
	* DECLARE @MB INT = 0;
	* EXECUTE [getFreeSpaceDrive]
		N'E',  @MB_Free = @MB OUTPUT;
	* PRINT CAST(@MB AS VARCHAR(10));
	*/
	SET NOCOUNT ON;
	create table #FreeSpace (Drive char(1), MB_Free int);
	insert into #FreeSpace exec xp_fixeddrives
	SET @MB_Free = (select MB_Free 
	from #FreeSpace WHERE Drive = @drive);
	
	DROP TABLE #FreeSpace;
	SET NOCOUNT OFF;
	RETURN;
END;