The purpose of the Alerts sample is to demonstrate the alert capabilities of Microsoft SQL Server 2005. For information about this new feature, refer to the topic, "Defining Alerts" in SQL Server Books Online.
Samples are provided for educational purposes only. They are not intended to be used in a production environment and have not been tested in a production environment. Microsoft does not provide technical support for these samples. Sample applications should not be connected to or used with your production SQL Server database without the permission of the system administrator.
From SQL Server Management Studio, open the agent_sample_alerts.sql script. The default installation directory is drive:\Program Files\Microsoft SQL Server\90\Samples\Engine\Administration\Alerts\Scripts.