This project is read-only.


[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

This sample works only with SQL Server 2005 and SQL Server "Katmai". It will not work with any version of SQL Server earlier than SQL Server 2005.
The purpose of the Alerts sample is to demonstrate the alert capabilities of SQL Server. For more information, see "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 and assemblies should not be connected to or used with your production SQL Server database or your report server without the permission of the system administrator.


This sample script file creates SQL Server Agent alerts in SQL Server.
After the execution of this script you will find new alerts added to the alerts collection. You could examine them in SQL Server Management Studio or by calling sphelpalert stored procedure.




Before running this sample, make sure the following software is installed:
  • SQL Server, including the following components:

SQL Server Database Engine and samples
  • SQL Server Management Studio
  • Database Engine samples

Running the Sample

The following procedure shows how to run the Alerts sample.

Running the Alerts Sample

  1. From Management Studio, open the agentsamplealerts.sql script. The default installation directory is C:\Program Files\Microsoft SQL Server\100\Samples\Engine\Administration\Alerts\Scripts.
  2. Click Execute. © 2007 Microsoft Corporation. All rights reserved.

Last edited Mar 6, 2007 at 9:06 PM by bonniefe, version 1


No comments yet.