This topic has not yet been rated - Rate this topic

Notification Services Stored Procedures (Transact-SQL)

Windows Server 2003

Many administrative, debugging, and troubleshooting activities in Microsoft SQL Server 2005 Notification Services can be performed through stored procedures. The public stored procedures are grouped into the categories shown in the following tables.

Administration and Reporting Stored Procedures

NSAdministrationHistory	NSSnapshotEvents
NSSnapshotApplications	NSSnapshotProviders
NSSnapshotDeliveryChannels	NSSnapshotSubscriptions
NSVacuum

Debugging Stored Procedures

NSExecuteRuleFiring	NSSetQuantumClock
NSPrepareRuleFiring	NSSetQuantumClockDate

Event Submission Stored Procedures

NSEventBeginBatch<EventClassName>	NSEventSubmitBatch<EventClassName>
NSEventFlushBatch<EventClassName>	NSEventWrite<EventClassName>

Troubleshooting and Analysis Stored Procedures

NSDiagnosticDeliveryChannel	NSQuantumDetails
NSDiagnosticEventClass	NSQuantumExecutionTime
NSDiagnosticEventProvider	NSQuantumFailures
NSDiagnosticFailedNotifications	NSQuantumList
NSDiagnosticNotificationClass	NSQuantumPerformance
NSDiagnosticSubscriptionClass	NSQuantumsSkipped
NSEventBatchDetails	NSScheduledSubscriptionDetails
NSEventBatchList	NSScheduledSubscriptionList
NSNotificationBatchDetails	NSSubscriptionConditionInformation
NSNotificationBatchList

Note:
Unless otherwise indicated, datetime values in Notification Services are in Universal Coordinated Time (UTC).

Note:
Unless otherwise indicated, all system stored procedures return a value of 0 to indicate success and a nonzero value to indicate failure.

Other Notification Services Stored Procedures

The instance database and application databases contain stored procedures that are not documented in this stored procedure reference. Undocumented stored procedures are intended for internal use only. Calling them explicitly from your applications is not supported and might cause unexpected behaviors in your Notification Services applications.

Reference

System Stored Procedures (Transact-SQL)
Notification Services Views

Other Resources

Monitoring Notification Services Performance and Activity

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD