Removes all notifications sent to a particular operator in response to an alert.
sp_delete_notification [ @alert_name = ] 'alert' ,
[ @operator_name = ] 'operator'
[@alert_name =] 'alert'
Is the name of the alert. alert is sysname, with no default.
[@operator_name =] 'operator'
Is the name of the operator. operator is sysname, with no default.
0 (success) or 1 (failure)
Removing a notification removes only the notification; the alert and the operator are left intact.
Only members of the sysadmin fixed server role can execute sp_delete_notification.
This example removes all notifications sent to operator stevenb when alert 'Error 1101' occurs.
USE msdb EXEC sp_delete_notification 'Error 11001', 'stevenb'