Enabling SQL Service Broker Hangs Indefinitely

Posted on

We are using Octopus Deploy to perform model-driven deployments to our SQL Server databases based on the DacPac created in a Visual Studio Database project. One of the post-deployment scripts was hanging indefinitely: IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = ‘MyDatabase’ AND is_broker_enabled = 1) ALTER DATABASE [MyDatabase] SET ENABLE_BROKER This is […]