How to check if Broker Service is enabled in SQL Server?
To Verify if the Broker Service is enabled on SQL Database, run the following Query:
