CODEWITHSUNDEEP
sql-serverservice-brokerazure-sql-managed-instance
bjnr
bjnr

Reputation: 3437

Service Broker not supported in Azure SQL managed instance?

Even Service Broker seems to be available for Azure SQL managed instance, I was able to activate it, when I run:

CREATE QUEUE ExpenseQueue;

, I get the error:

Statement 'CREATE QUEUE' is not supported in this version of SQL Server.

Any idea how to fix this?

Upvotes: -1

Views: 256

Answers (1)

bjnr
bjnr

Reputation: 3437

Indeed, the Azure SQL wasn't a managed instance. Everything worked normal after setting up a managed instance.

Upvotes: 0

Related Questions