Disk Size

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736504 More actions · Answer 1

xp_cmdshell 'dir c:' will get you this, but you have to parse.

Steve Jones

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 2

That would give the free disk space. Is there a dos command to see the total disk space (used and not)

David Burrows SSC Guru Points: 65143 More actions · Answer 3

Try

declare @o int, @d int, @t varchar(255)

exec sp_oacreate 'scripting.filesystemobject', @o out

exec sp_OAmethod @o, 'GetDrive', @d OUT, 'C:'

exec sp_OAGetProperty @d, 'TotalSize', @t OUT

select @t

exec sp_oadestroy @o

Far away is close at hand in the images of elsewhere.
Anon.

dannibrook SSC Veteran Points: 212 More actions · Answer 4

SSC Veteran

Points: 212

February 27, 2003 at 8:28 pm

Thanks David

The script works fine.