Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Manage Administration Tasks > Configure Service Broker Communications > Event Notifications > Event Notification Properties

Define General Event Notification Properties

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

Scope

Indicates where the event must occur in order to generate a notification.

Server to generate a notification when the event occurs anywhere within the current SQL Server instance
Database to generate a notification when the event occurs anywhere within the current SQL Server instance
Queue to generate a notification when the event occurs in the specified queue

With fan_in

Applies the 'With fan-in' option to the event notification. With this option, SQL Server sends only one notification for all event notifications that:

Are created on the same event
Are created by the same principal
Specify the same service and broker_instance_specifier
Specify WITH FAN_IN

Specify the events that generate a notification on the SQL Events, Trace Event and Queue Events pages.