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 |
|
kappa02
Yak Posting Veteran
65 Posts |
 Posted - 2013-03-28 : 16:10:49
|
I have a job which uses sp_send_dbmail, it's been running fine now it's giving an error message: "Msg 14650, Level 16, State 1, Procedure sp_send_dbmail, Line 69 Service Broker message delivery is not enabled in this database." When looking at sys.databases I see that "is_broker_enable" is set to 1 for that database. What can one do to fix this, I do recall on of the administrators doing a restore to MSDB, I'm sure that was the cause but what can be done to fix the job. run this: ALTER DATABASE db_name SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE  |
|
|
|
|
|
Service Broker (is broke)