Notification Services Views
Views provide a consolidated look at instance and application data. Microsoft SQL Server 2005 Notification Services provides the views documented in this section for debugging, tracking, and troubleshooting Notification Services applications.
Important
Microsoft strongly recommends that you use the documented views and stored procedures instead of working with Notification Services tables directly; the data in these tables must be inserted, updated, and deleted in specific ways that are enforced by stored procedures.
In This Section
| Topic | Description |
|---|---|
Describes the view named after an event class, which you can use to insert events to the event class. |
|
Describes the view named after a notification class, which you can use to review the notifications being processed by the application. |
|
Describes the NSNotificationClassNameNotificationDistributionView view, which provides a log of all delivery attempts for notifications of the associated notification class. |
|
Describes the NSSubscriptionClassNameView view, which shows all subscriptions for the associated subscription class. |
|
Describes the NSEventBatchView, which lists the event batches for all event classes in the application. |
|
Describes the NSFullTimeZones view, which provides a list of the Notification Services time zones. |
|
Describes the NSSubscriberDeviceView view, which shows subscriber and subscriber device information for the instance. You can use this view to manage subscriber devices. |
|
Describes the NSSubscriberView, which list the subscribers to the instance of Notification Services. You can use this view to manage subscribers. |
The instance and application databases contain additional views. These views are used internally by Notification Services and should not be used for other purposes.
See Also
Reference
Notification Services Tables
Notification Services Stored Procedures (Transact-SQL)