How to check if the service broker is enabled at the server level and whether it is being utilized?

-1 votes

1 answer

3274 views

                          The following query return 1 for is_broker_enabled for a couple of databases. However, I don't recollect ever using the service broker feature.

    SELECT db.database_id, db.[name] AS [Database Name], is_broker_enabled
    FROM sys.databases AS db 

How to check if the service broker is enabled at the server level and whether it is being utilized?

Asked by variable (3590 rep)

Apr 13, 2022, 08:42 AM
Last activity: Jan 7, 2023, 04:06 AM

How to check if the service broker is enabled at the server level and whether it is being utilized?

Related Questions