I need to wrtie scripts that can automatically email me the current sql server 2000 or 2005 total valumn versus the hard drive (i.e. 200G total database files plus the log files versus 500G for the hard drive which is 40% used up).

the script could be in VBScript or the WMI scripts that I can put it on the MOM server.

Please advice how to do it.

thank you!