sp_dropalert SQL Executive Stored Procedure

Drops an alert.

Syntax

sp_dropalert name

where

name

Specifies which alert to drop.

Remarks

This stored procedure must be run from the msdb database.

Dropping an alert also drops all the associated notifications for that alert.

SQL Enterprise Manager provides an easy, graphical way to manage the entire alerting system. Using SQL Enterprise Manager is the recommended way to configure your alert infrastructure.

Example

This example drops the 'Test Alert' alert.

sp_dropalert 'Test Alert'

Permission

Only the system administrator can use this procedure.

Tables Used

sysalerts, sysnotifications

See Also