I cannot enable Service Broker on SQL Server database

510 views Asked by user3057544 At 03 April 2023 at 05:08

When I try to send email using:

EXEC sp_send_dbmail

I get this error:

Service Broker message delivery is not enabled in this database. Use the ALTER DATABASE statement to enable Service Broker message delivery.

So I am trying to execute:

USE master;
GO
ALTER DATABASE [MyDatabaseName] SET ENABLE_BROKER;
GO

But the above statement is running infinitely without error message or timeout.

When I run below statement:

select name, is_broker_enabled from sys.databases

I can see that service broker is still disabled.

TechQA.