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
|
|---|
|
<EventClassName> View
|
Describes the view named after an event class, which you can use to insert events to the event class.
|
|
<NotificationClassName> View
|
Describes the view named after a notification class, which you can use to review the notifications being processed by the application.
|
|
NS<NotificationClassName>NotificationDistribution View
|
Describes the NSNotificationClassNameNotificationDistributionView view, which provides a log of all delivery attempts for notifications of the associated notification class.
|
|
NS<SubscriptionClassName>View
|
Describes the NSSubscriptionClassNameView view, which shows all subscriptions for the associated subscription class.
|
|
NSEventBatchView
|
Describes the NSEventBatchView, which lists the event batches for all event classes in the application.
|
|
NSFullTimeZones View
|
Describes the NSFullTimeZones view, which provides a list of the Notification Services time zones.
|
|
NSSubscriberDeviceView
|
Describes the NSSubscriberDeviceView view, which shows subscriber and subscriber device information for the instance. You can use this view to manage subscriber devices.
|
|
NSSubscriberView
|
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