<NotificationClassName> View

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.

Important

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.

View Columns

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.

Remarks

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

Permissions

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

See Also

Reference

INSERT (Transact-SQL)
Notification Services Views

Other Resources

Subscriber Locale Codes
Subscription Processing Architecture
Enabling and Disabling Instances, Applications, or Components

Help and Information

Getting SQL Server 2005 Assistance