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
Unless otherwise indicated, datetime values in Notification Services are in Universal Coordinated Time (UTC).
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.