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/scrip...le.php/1470811
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com
|||More information about how xp_fixeddrives might be used.
http://databasejournal.com/features/...le.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 ?
>