Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 14, 2012 6:36 AM
Points: 17, Visits: 37
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
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.

CEWII
Post #1242477
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse