Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    7

    Question Unanswered: db Full auto-notification

    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 ;-)

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Go thru books online on setting ALERTS and use ERROR 1105 to inform the status of the database size if its full by 90%.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •