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
Alok

alok.gupta (AT) gmail (DOT) com (Alok) wrote in message news:<5dff41b9.0407140514.70119b1c (AT) posting (DOT) google.com>...
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.

Simon