How can I get the get the size of a disk?

[NathanGriffiths]

I need a SP or function that will return the size of a physical disk (not just the free space, as given by xp_fixeddrives), e.g.

C: 1000MB
D: 5000MB

Any suggestions?

thanks,


Nathan

----------------------------------------
Want to get a good response to your question? Read this FAQ! -> faq183-874
----------------------------------------

 

[nigelrivett]

You can use the scripting.filesystemobject which has a drives collection with a totalsize property for each drive.

Never used it for this but here's an example of using it in an SP.

http://www.nigelrivett.net/CheckIfFileExists.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.