Is the anyway to run a query that will show free disk space on dat

Is the anyway to run a query that will show free disk space of all hard
drives on the
server?
-D
master..xp_fixeddrives
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"D'Animal" wrote:

> Is the anyway to run a query that will show free disk space of all hard
> drives on the
> server?
> -D
|||Also sp_diskspace http://www.sqldbatips.com/showcode.asp?ID=4
This procedure returns the amount of free space (in MB) on all fixed disks
on the SQL Server using xp_fixeddrives but builds on that by using the
FileSystemObject to get the total drive space and calculate the free space
percentage
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"D'Animal" <D'Animal@.discussions.microsoft.com> wrote in message
news:75D859FA-0379-4885-A26B-2D84F3C7E207@.microsoft.com...
> Is the anyway to run a query that will show free disk space of all hard
> drives on the
> server?
> -D
sql