When a subscription rule generates a notification , it inserts raw notification data into the notification table 订阅规则生成通知时,它会将原始通知数据插入通知表中。
The query specifies the query that selects subscription and input fields and adds them to the notification table 该查询指定了选择订阅和输入字段并将其添加到通知表中的查询。
The scheduled rules insert the resulting notifications into notification tables ; this data is used to build and distribute notifications 预定规则将结果通知插入通知表中;此数据用于生成和分发通知。
These tables include system base tables , xml indexes , full - text indexes , service broker queue tables , and query notification tables 这些表包括系统基表、 xml索引、全文索引、 service broker队列表和查询通知表。
These tables include system base tables , xml indexes , full - text indexes , service broker queue tables , and query notification tables 这些表包括系统基表、 xml索引、全文索引、 service broker队列表和查询通知表。
The view returns only the current set of events , whereas the notification table contains all events that have not been removed via vacuuming 视图仅返回当前事件集,而通知表包含尚未通过清空操作删除的所有事件。
Notifications are accumulating in the notification tables and the distributor is formatting notifications and delivering them to the delivery channels 通知在通知表中累积,分发服务器正确格式化通知并将通知传递到传递通道。
If you try to insert notifications outside of a subscription rule firing , the preparation and cleanup does not happen , which causes failures 如果尝试将通知插入订阅规则触发之外的通知表中,则不执行准备和清理操作,这样会导致失败。
Verify that your notification generation rules are not directly accessing the notification table when they should be accessing a view named after the notification class 验证当您的通知生成规则应访问与通知类同名的视图时,并不直接访问通知表。
Name the notification class and optionally designate the sql server filegroup for the database objects associated with the notification class such as the notification table 命名通知类,指定与通知类关联的数据库对象(如通知表)的sql server文件组(可选) 。