Service Broker Disabled but it comes back showing its Enabled.

Used to disable SERVICE BROKER in single user mode :

ALTER DATABASE [Database_name] SET DISABLE_BROKER;

SELECT is_broker_enabled FROM sys.databases WHERE name = 'Database_name';

when i checked the database after disabling, it shows 'is_broker_enabled'=1

wht can be problem.

April 27th, 2015 9:41pm

see some troubleshooting here.

How to enable, disable and check if Service Broker is enabled on a database
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 10:26pm

Interestingly the broker is disabled but i see the receive_wait messages on 'Activity monitor' for the database where service broker is disabled.

Any thoughts

April 29th, 2015 11:24pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics