The SQL Server Service Broker for the current database is not enabled

The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications.

----Check if the service broker is enabled
SELECT is_broker_enabled FROM sys.databases WHERE name = 'YOUR_DB'

-- Enable broker
ALTER DATABASE YOUR_DB SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE

-- If fail above then new broker
ALTER DATABASE YOUR_DB SET NEW_BROKER WITH ROLLBACK IMMEDIATE

Comments

Post a Comment

Popular posts from this blog

Post packing slip of sales order in X++

SalesFormletter SalesFormletter; SalesTable SalesTable; ; SalesFormletter = SalesFormletter::construct(DocumentStatus::Confirmation,true); SalesTable.clear(); SalesTable = SalesTable::find(_salesId); SalesFormletter.update(SalesTable, systemDateGet(), SalesUpdate::All, AccountOrder::None, false, false);
Read more