Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbist
Yak Posting Veteran
52 Posts |
 Posted - 2008-04-04 : 15:50:48
|
| hello,I am trying to enable service broker by issuing this command:USE master ;GOALTER DATABASE msdb SET ENABLE_BROKER ;GOIt 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? |
|
|
dbist
Yak Posting Veteran
52 Posts |
Posted - 2008-04-04 : 16:09:37
|
| nevermind, I put it in single user and did it right away. |
 |
|
|
|
|
|
question abt turning on svc brker for msg delivery