Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SQL Server Service Broker Utils
-- Verify the state of the service broker in SQL Server Management Studio
-- Database -> Properties -> Options -> Service Broker Tab -> Broker Enabled
-- To enable broker
ALTER DATABASE [database] SET ENABLE_BROKER
-- To disable broker
ALTER DATABASE [database] SET DISABLE_BROKER
-- When having multiple service brokers, each service broker must have an unique identifier to run.
-- Run this if ENABLE_BROKER returns an error.
ALTER DATABASE [database] SET NEW_BROKER
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment