/*------------------------------------------------------------------------------------------------------------

03/13/2009

In this script we use extended stored procedure named xp_fixeddrives to find disk drive space
We creae a temp table and then use xp_fixeddrives to populate the data and then dispay it


------------------------------------------------------------------------------------------------------------*/



--declarations

declare @Free_Megabytes int

--drop and create a temp table

drop table #Drive_Space
create table #Drive_Space(
 Disk_Drive char(5), 
 Free_Megabytes bigint
)

--insert the drive information

insert into #Drive_Space exec xp_fixeddrives

--display the drive information

select * from #Drive_Space



/*

Compiled by http://www.learningsqlserver2008.com/, Kash Data Consulting LLC 

Disclaimer:

All sample code and scripts are compiled by Kash Data Consulting LLC for illustrative purposes only. Kash Data Consulting LLC, 
therefore, cannot guarantee or imply reliability, or function of this code or scripts.

All code contained herein are provided to you "AS IS" without any warranties of any kind. Please test all code and 
scripts in test environment before deployment in production systems.

*/