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
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
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