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 05, 2010 1:13 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 1:01 PM
Points: 89, Visits: 319
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 05, 2010 8:35 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 5:30 PM
Points: 1,264, Visits: 721
I know for sure that Database Mail depends on Service Broker activated for msdb.
Post #916629
Posted Thursday, May 06, 2010 12:22 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 1:01 PM
Points: 89, Visits: 319
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