DROP EVENT NOTIFICATION

Remove an event notification trigger from the current database.

Syntax
DROP EVENT NOTIFICATION notification_name [,...n ]
ON { SERVER | DATABASE | QUEUE queue }[;]

Key:
notification_name Name of the event notification to remove.
SERVER Apply to the current server
DATABASE Apply to the current database
queue The name of the queue

Options must must be specified as they originally were when the event notification was created.

Example

DROP EVENT NOTIFICATION testnotify

__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)