Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Notification Services Views

SQL Server 2005

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.

ms173433.note(en-US,SQL.90).gifImportant:
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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.