Post reply

Enable Service Broker in Server level

  • February 23, 2016 at 11:00 am

    #305019

    Is there a way service broker can be enabled in server level ?

  • February 23, 2016 at 12:38 pm

    #1860539

    ALTER DATABASE [model] SET ENABLE_BROKER;

    Should make any new Databases have service broker enabled.

    You'd still need to update the rest of the DB's where it's not:

    SELECT name, is_broker_enabled FROM sys.databases

    where is_broker_enabled = 0

  • February 23, 2016 at 1:10 pm

    #1860549

    Thank you.So it is basically done for each database.

  • February 23, 2016 at 1:31 pm

    #1860557

    If you have tons of databases to do it on, you could create a cursor to loop through the databases and then run the SQL to enable service broker. Should be only a few lines. Depends if all the databases are on the same server.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply