How To find Disc Free space from MS SQL 2000 query -- sql server (alternate)

alok.gupta NO[at]SPAM gmail.com
7/14/2004 6:14:01 AM

Hi all,
I have to find free disc space in a drive from SQL Query and i am
using MSSQL200. Does any body know the command for the same.

Also if i want to find hard disk space of a different machine on
network, it is possible to get the data??

Also can i get the CPU/Memory usage data of our machine by some
SQL/C++ commands??

Please let me know if u know any of the answer...

thanks

sql NO[at]SPAM hayes.ch
7/15/2004 2:31:42 AM

[quoted text, click to view]

exec master..xp_fixeddrives

But this is not documented, so you should not rely on it. In many
cases, retrieving information about the operating system is very
awkward from SQL, and you should probably look at Performance Monitor
or an interface like WMI to get this information more easily.

sql server (alternate) : How To find Disc Free space from MS SQL 2000 query