This topic has not yet been rated - Rate this topic

NSSubscriberView

SQL Server 2005

Notification Services creates one subscriber view per Notification Services instance. This view is located in the instance schema of the instance database. For example, the instance configuration specifies that the schema name is Tutorial, the view is Tutorial.NSSubscriberView.

You can use this view to add, modify, and delete subscribers to an instance of Notification Services. For deployed applications, consider developing a subscription management interface using the subscription management API. For more information, see Developing Subscription Management Interfaces.

View Columns

Column	Data type	Description
SubscriberId	nvarchar(255)	The subscriber identifier. This value is an identifier of your choice. It must be unique within the Notification Services instance.
Enabled	bit	Determines if the subscriber record is enabled (1) or disabled (0). If it is disabled, the subscriber's subscriptions will not generate notifications.
Created	datetime	The date and time the subscriber record was created. Do not insert values into this column. Notification Services sets this value when you add the subscriber.
Updated	datetime	The date and time the subscriber record was modified. Do not insert values into this column. Notification Services sets this value when you update the subscriber.

Remarks

To insert data, the subscribers must be enabled.

Permissions

This view is available to members of the NSEventProvider, NSRunService, and db_owner database roles and the sysadmin server role.

Examples

Use the following query to insert a subscriber into the Tutorial instance, which uses the TutorialNSMain database:

USE TutorialNSMain;
GO
INSERT INTO dbo.NSSubscriberView (SubscriberId, Enabled)
VALUES (N'danw@adventure-works.com', 1);
GO

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

NSSubscriberView

Reference

Other Resources

Help and Information

Community Additions