Stack Exchange network consists of 175 Q&A communities includingStack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Detailed answers to any questions you might have

Discuss the workings and policies of this site

Learn more about hiring developers or posting ads with us

By using our site, you acknowledge that you have read and understand ourCookie PolicyPrivacy Policy, and ourTerms of Service.

Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

The best answers are voted up and rise to the top

I am trying to set up query notification however when I try to create a queue and service I get the error There is no Service Broker active in the database. Change to a database context that contains a Service Broker. When I run the query

It returns 1 which means that a broker has been enabled on the database

Here are the sql commands I am running to create my queue and service…

You just get the message that Service Broker isnt enabled. But you query the system databases, not your current Database. Just as an idea, might it be, that you run the Script for setting up the notification in your

database while you forget to change the database context to your

Otherwise try to enable/disable the Service Broker in your

By clicking Post Your Answer, you agree to ourterms of serviceprivacy policyandcookie policy

Unicorn Meta Zoo 3: How do we grade questions?

Is it ok to put a subplot to a story that is never meant to contribute to the development of the main plot?

What is the best linguistic term for describing the kw p / gw b change, and its usual companion s h

Is there any use case for the bottom type as a function parameter type?

In what episode of TOS did a character on the bridge make a comment about raising one to some power?

What was this black-and-white film set in the Arctic or Antarctic where the monster/alien gets fried in the end?

Is a post-climate apocolypse city in which many or most insects have disappeared realistic?

The Passive Wisdom (Perception) score of my character on D&D Beyond seems too high

How did early x86 BIOS programmers manage to program full blown TUIs given very few bytes of ROM/EPROM?

Looking after a wayward brother in mothers will

Which noble houses were destroyed during the Game of Thrones?

site design / logo 2019 Stack Exchange Inc; user contributions licensed undercc by-sa 3.0withattribution required.rev2019.5.24.33810