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?
-Dmaster..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

Is NTFS required?

Good day. I had my XP Pro PC hard drives formatted to NTFS but when I built
the 98SE PC it could not read the shared files from the XP PC. I
re-formatted the drives on the XP PC to FAT32. Does the PC on which SQL
Server 2000 is installed require the NTFS formatted hard drives? TIA, Jim.
AFAIK, no.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Jim Richards" <JWRichards@.satx.rr.com> schrieb im Newsbeitrag
news:nS%qe.39974$j51.31328@.tornado.texas.rr.com...
> Good day. I had my XP Pro PC hard drives formatted to NTFS but when I
> built the 98SE PC it could not read the shared files from the XP PC. I
> re-formatted the drives on the XP PC to FAT32. Does the PC on which SQL
> Server 2000 is installed require the NTFS formatted hard drives? TIA, Jim.
>
|||Not required but it is recommended according to Books Online.
Only Personal Ed and MSDE are supported as servers on Win98, although
Win98 clients are OK for all editions.
David Portas
SQL Server MVP

Is NTFS required?

Good day. I had my XP Pro PC hard drives formatted to NTFS but when I built
the 98SE PC it could not read the shared files from the XP PC. I
re-formatted the drives on the XP PC to FAT32. Does the PC on which SQL
Server 2000 is installed require the NTFS formatted hard drives? TIA, Jim.AFAIK, no.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Jim Richards" <JWRichards@.satx.rr.com> schrieb im Newsbeitrag
news:nS%qe.39974$j51.31328@.tornado.texas.rr.com...
> Good day. I had my XP Pro PC hard drives formatted to NTFS but when I
> built the 98SE PC it could not read the shared files from the XP PC. I
> re-formatted the drives on the XP PC to FAT32. Does the PC on which SQL
> Server 2000 is installed require the NTFS formatted hard drives? TIA, Jim.
>|||Not required but it is recommended according to Books Online.
Only Personal Ed and MSDE are supported as servers on Win98, although
Win98 clients are OK for all editions.
David Portas
SQL Server MVP
--