To configure database mail, you need to enable service broker on MSDB databse. Make sure that Sql Server Agent is stoped before running the following query below.
ALTER DATABASE MSDB
SET ENABLE_BROKER
To check that service broker has been enabled, run this piece of sql below.
SELECT IS_broker_Enabled
FROM sys.databases
WHERE name = 'MSDB'
If 1= Broker enabled.
If 0 = Broker Not enabled.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment