Hi,

Sqlserver2018 Sage database, who used the “notification query” function? does it create problems for Sage's normal work?

Sage X3 Version 11.12

ALTER DATABASE NAME_DATABASE SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;

CREATE QUEUE PortalNotificationQueue

CREATE SERVICE PortalNotificationService ON QUEUE PortalNotificationQueue ([http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification])

CREATE ROUTE NotificationMessagesRoute WITH SERVICE_NAME = 'PortalNotificationService', ADDRESS = 'LOCAL'