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

TempDB and Service broker question Expand / Collapse
Author
Message
Posted Wednesday, May 5, 2010 1:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, November 15, 2014 7:30 PM
Points: 101, Visits: 362
Howdy,

Does the service broker need to be enabled on tempdb/msdb? I noticed in the sys.databases view that it's enabled in our instances so I guess this is the default.

I honestly don't know much about the service broker. Been reading up on it but can't seem to find anything specific about it in relation to tempdb/msdb using it (other than tempdb being used for processing broker data by other databases where it is enabled) , because we don't have anything set up that would. Would like to disable it if its not needed.

Thanks,
Scott
Post #916391
Posted Wednesday, May 5, 2010 8:35 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:08 AM
Points: 1,264, Visits: 736
I know for sure that Database Mail depends on Service Broker activated for msdb.
Post #916629
Posted Thursday, May 6, 2010 12:22 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, November 15, 2014 7:30 PM
Points: 101, Visits: 362
makes sense i can see why it'd be on for msdb but not sure about tempdb. anybody out there know the answer?

thanks,
scott
Post #917291
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse