April 12, 2007 at 2:26 pm
I am looking for the easiest approach in the point of view from DBAs.
Any input is greatly appreciated.
April 12, 2007 at 3:10 pm
xp_fixeddrives
Or maybe use VBScript and the FileSystemObject. That might be the easiest.
April 12, 2007 at 9:20 pm
Use the free PSINFO utility from http://www.sysinternals.com
C:\>PSINFO -D DISK \\SERVERNAME
PsInfo v1.73 - Local and remote system information viewer Copyright (C) 2001-2005 Mark Russinovich Sysinternals - www.sysinternals.com
System information for \\SERVERNAME:
Volume Type Format Label Size Free Free A: Removable 0.0% C: Fixed NTFS 37.27 GB 20.50 GB 55.0% D: Removable 0.0% E: CD-ROM 0.0% F: CD-ROM 0.0%
C:\>
April 13, 2007 at 11:39 am
See http://www.sqldbatips.com/showcode.asp?ID=4 I use the script often and it works great.
Francis
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply