SQL Server Service Broke not working as expected (expected behavior)

When your SQL Server queue encounters an issue, it could stem from a variety of potential issues such as misconfigured setting parameters, problems related to the underlying infrastructure like the SQL Server Service Broker, or inherent configuration flaws within the queue itself. Here’s a guide detailing potential causes and solutions for troubleshooting your SQL Server queue issues.

Check SQL Server Service Broker enabled or not

The Service Broker should be enabled within the database where your queue is located. It can be verified using the following command.

    SELECT is_bro