CREATE EVENT NOTIFICATION

Create an event notification trigger, that may in turn send event information to a service broker.

Syntax
CREATE EVENT NOTIFICATION event_notification
ON { SERVER | DATABASE | QUEUE queue }
[WITH FAN_IN ]
FOR {event_type | event_group } [ ,...n ]
TO SERVICE 'broker_service' ,
{'broker_instance_specifier' | 'current database' } [; ]


Key:
notification_name Name of the event notification to remove.
SERVER Apply to the current server
DATABASE Apply to the current database
queue_name 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)