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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment