Can a SQL Server stored procedure do that ?

There is a stored procedure, namely sp_spaceused, to find out the space used
of a particular database.
But now, I also want to record the free hard disk space of each of my
server's logical drives, eg. C drive, D drive, ... into my SQL Server
database, is there any stored procedure just like sp_spaceused to find a
logical disk's free space ?Try this undocumented xp:
master.dbo.xp_fixeddrives
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:ca9qn3$oec1@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space
used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>|||you can take a look at following url.
http://www.databasejournal.com/scri...cle.php/1470811
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com|||More information about how xp_fixeddrives might be used.
http://databasejournal.com/features...cle.php/3080501
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:ca9qn3$oec1@.imsp212.netvigator.com...
> There is a stored procedure, namely sp_spaceused, to find out the space
used
> of a particular database.
> But now, I also want to record the free hard disk space of each of my
> server's logical drives, eg. C drive, D drive, ... into my SQL Server
> database, is there any stored procedure just like sp_spaceused to find a
> logical disk's free space ?
>