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

"Even a minor event in the life of a child is an event of that child's world and thus a world event " - Gaston Bachelard

Related commands:

DROP EVENT NOTIFICATION
ALTER ANY DATABASE EVENT NOTIFICATION (Database)
ALTER ANY EVENT NOTIFICATION (Server)