Notification Services Stored Procedures (Transact-SQL)

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

Debugging Stored Procedures

Event Submission Stored Procedures

Troubleshooting and Analysis Stored Procedures

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.

See Also

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