<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