Service Broker not supported in Azure SQL managed instance?

173 Views Asked by At

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?

1

There are 1 best solutions below

0
bjnr On

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