Notification Services Tables
Notification Services instance and application databases contain many tables. These tables hold the following types of data:
- Metadata, which is a normalized representation of the information from the instance configuration and the application definitions.
- Application data, such as events, subscriptions, and notifications.
- Transient data generated by Notification Services when processing information.
When you configure an instance of Notification Services and define individual applications, you can specify a database name and schema for instance database objects and a database name and schema for each application's database objects. If you specify schema names, instance and application objects are created in the specified schemas. If you do not specify schema names, instance and application objects are created in the dbo schema. For more information, see Defining the Instance Database and Defining the Application Database.
Notification Services also has tables in the msdb database. These tables contain metadata about Notification Services applications and instances. The information in these tables is updated when you create and delete instances and when you run nscontrol repair.
Do not modify data in Notification Services tables. The data in these tables must be inserted, updated, and deleted in specific ways as enforced by stored procedures. The table names and definitions can change at run time, do change when you update the application, and might change in future releases. Instead of directly using the tables, use the documented stored procedures and views provided with Notification Services to access instance and application data. Also, always update instances of Notification Services using the nscontrol update command, the Update Instance dialog in SQL Server Management Studio, or the Update method.