April 4, 2008 at 1:42 pm
hello,
I am trying to enable service broker by issuing this command:
USE master ;
GO
ALTER DATABASE msdb SET ENABLE_BROKER ;
GO
It is taking a while to do that and I am wondering whether msdb needs to be in single user mode? Some smaller dbs completed right away. Going through Surface area config I got a message that I need a service broker endpoint and I looked at my other db and that has dbmail functioning and same message saying this instance needs an endpoint in surface config, what do you think is wrong?
Thanks.
April 4, 2008 at 2:16 pm
nevermind this, I put msdb into single user and ran my query, service broker is enabled.
April 4, 2008 at 2:37 pm
Yes, it does require that there are no other users of the database and will wait for them to leave.
Alternatively, you can use:
ALTER DATABASE msdb SET ENABLE_BROKER with rollback immediate
which will throw everyone else out for you (rude, but effective).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 4, 2008 at 3:23 pm
thank you, I like to be a rude DBA 🙂
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply