Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Service Broker Expand / Collapse
Posted Thursday, January 26, 2012 1:41 PM


Group: General Forum Members
Last Login: Thursday, October 13, 2016 8:30 AM
Points: 18, Visits: 38
Is Service Broker activated when Notification Services is installed? I have multiple servers where I set up mail notification and the only time it ever asked for Service Broker to be activated was on a server that didn't have Notification Services. The relation seems logical to me but I can't find it in writing anywhere. thx.
Post #1242442
Posted Thursday, January 26, 2012 2:35 PM



Group: General Forum Members
Last Login: Thursday, December 17, 2015 11:50 AM
Points: 6,050, Visits: 5,314
Database Mail uses service broker so it needs to be enabled, this has been true since SQL 2005. I believe but am not sure that Notification Services in SQL 2005 uses Database Mail to send email. I also know that Notification Services was removed from SQL 2008 and is not available so I would recommend not using it and planning a different path moving forward.

Post #1242477
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse