You receive the below error when you try to enable service broker on a database.
This usually happens
Msg 9772, Level 16, State 1, Line 1
The Service Broker in database "<Database Name>" cannot be enabled because there is already an enabled Service Broker with the same ID. Msg 5069, Level 16, State 1, Line 1 ALTER DATABASE statement failed. |
This usually happens
- When the service broker is enabled on a database and it is overwritten and then you try to enable the service broker on it again
- When the service broker is enabled on a database and it is renamed and another database with the same name is created and then you try to enable the service broker on it again.
To fix this error, run the below command which will generate the new ID for the service broker.
ALTER DATABASE <Database Name> SET NEW_BROKER
3 comments:
I do not even understand how I ended up right
here, however I believed this submit used to be great.
I don't understand who you might be but definitely you're going to a well-known blogger in the event you aren't already.
Cheers!
Review my page :: Business Advice; bat17.co.uk,
Hi, everyone! I know how hard it is to find the good tracking app for kids nowadays, but I have something special for you! Try this ipad spy app and you will have access to their location 24/7! Don't hesitate and try it now! Enjoy and have a good day!
If you are looking for a software or app to keep an eye on your loved ones or protect them from online dangers like cyberbullying. I've something which is very helpful for you and that is tablet spy app which helps you to protect your loved ones from any kind of online dangers.
Post a Comment