• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 132
  • Last Modified:

configure service broker on all databases

Hello,

Is it possible to configure service broker on all databases during the setup and not setting it on model database?

Thanks

regards
0
bibi92
Asked:
bibi92
1 Solution
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Service broker (the service) by itself is available to the entire server. Whether a database can consume the service is governed by whether it has been enabled on the database or not.

The service broker identifier for each DB, the message types, contracts, queues, services, and stored procedures for the service are owned by the database - not by the server. Hence, you cannot have a central configuration at setup time - it needs to be done for each database.
0
 
bibi92Author Commented:
thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now