Hi All,

Is there a way to find the Drive / Disk space from Activex
Script.

Cheers,
Sanka

In article <030c01c3a494$db5b88b0$a101280a (AT) phx (DOT) gbl>, Sanka
<loonysan (AT) mailcity (DOT) com> writes
FileSystemObject - Drive Object, from MSDN docs-

Function ShowFreeSpace(drvPath)
Dim fso, d, s
Set fso = CreateObject("Scripting.FileSystemObject")
Set d = fso.GetDrive(fso.GetDriveName(drvPath))
s = "Drive " & UCase(drvPath) & " - "
s = s & d.VolumeName & "<BR>"
s = s & "Free Space: " & FormatNumber(d.FreeSpace/1024, 0)
s = s & " Kbytes"
ShowFreeSpace = s
End Function


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org