msdb and the broker-erer service

If you havent followed proper procedures when moving and restoring databases you might run into a problem with database mail like:

SQL Server Error: 14650, Service Broker message delivery is not enabled in this database. Use the ALTER DATABASE statement to enable Service Broker message delivery.

First stop the agent service.

Run the following:
ALTER DATABASE MSDB SET NEW_BROKER

Start the agent service…

Tape umbilical cord to belly button for fun, you saved the day!

Leave a Reply

Your email address will not be published. Required fields are marked *