Programatically monitor SQL SErver 2000?

How can I monitor (get access to how much space in a given DB is currently allocated, how much room is left, etc.) an SQL Server 2000 database programatically WITHOUT buying some sort of third party tool?

I want to be able to monitor the database from the web, and if I can get a stored procdure to retrieve the information I need, or even better still use a JDBC connection directly (no stored procdure call needed) to retrieve this sort of DB metadata, then I'm in business.

MANY THANKS!look into sp_spaceused system stored procedure.|||Thanks! That's a good start.

Originally posted by ms_sql_dba
look into sp_spaceused system stored procedure.

Program to monitor Sql server service

Can anyone help me with a program that can monitor my sql
server agent that will return an alert if the service
stops. I am using netiq and it only monitors sql server
service.H
If you have NetIQ'a Diagnostic Mangager it will notify you if the status of the SQLAgent changes (i.e. if it stops)
Otherwise, there are lots of little utilities that you can download for free to monitor a Windows service and notify you if it goes down. (for e.g. watchdog)