How To find Disc Free space from MS SQL 2000 query - 07-14-2004 , 08:14 AM
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
Please let me know if u know any of the answer...
Re: How To find Disc Free space from MS SQL 2000 query - 07-15-2004 , 04:31 AM
alok.gupta (AT) gmail (DOT) com (Alok) wrote in message news:<5dff41b9.0407140514.70119b1c (AT) posting (DOT) google.com>...
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.