Share via


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

<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

Reference

Notification Services Tables
Notification Services Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance