Hi everybody,
Is it possible to make an alert on MSSQL so that the Administrator is automatically notified (by email or net message for instance) when one of the db comes full, or when the free space goes under a critical level ?
Is the "available space" for each database stored in some table of the Master database ?
many thanks in advance for your help ;-)Go thru books online on setting ALERTS and use ERROR 1105 to inform the status of the database size if its full by 90%.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment