How do I set up a SQL 7.0 Server Alert to notify me when a particular database is 80% full?

-- Anonymous, November 02, 1999

Answers

Berni,

Use SQL Server Agent. From SQL Server Enterprise Manager, open the Management tree under your server by clicking on the + sign. If necessary, start SQL Server Agent by right clicking and selecting Start. Click on the + sign in front of SQL Server Agent. Right click on Alerts and select New Alert... On the General tab of the pop-up window, select a Type of SQL Server performance condition alert, an Object of SQLServer:Databases, a Counter of Data File(s) Size (KB), and an Instance of your database name. Set the Alert if counter to rises above and a Value of 80% of your database size. Then click the Response tab to set how you would like to be notified. You may need to start SQL Mail.

Hope this helps,

Eric

-- Anonymous, November 08, 1999