Export (0) Print
Expand All

<NotificationClassName> View

SQL Server 2005

Notification Services creates one view for each notification class defined in an application. This view has the same name as the notification class, and is located in the application's schema. For example, if an application has a notification class named WeatherAlerts and the application schema is News, the view is News.WeatherAlerts.

ms173742.note(en-US,SQL.90).gifImportant:
Do not insert data into this view. Only the generator, through the rules defined in actions and condition actions, can insert notifications into this view.

Column Data type Description

NotificationId

bigint

ID of the notification.

SubscriberId

nvarchar(255)

The ID of the subscriber for this subscription.

DeviceName

nvarchar(255)

The name of the subscriber device.

SubscriberLocale

nvarchar(10)

The subscriber's locale.

NotificationClassFieldName (1-n)

application-defined

All columns specified in the event class also appear in this view.

This view is in the application's database and schema.

This view is available to members of the NSGenerator, NSRunService, and db_owner database roles and the sysadmin server role.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft