CODEWITHSUNDEEP
sql-serverservice-broker
user3057544
user3057544

Reputation: 868

I cannot enable Service Broker on SQL Server database

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.

Upvotes: 0

Views: 1157

Answers (0)

Related Questions