May 5, 2010 at 1:13 pm
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
May 5, 2010 at 8:35 pm
I know for sure that Database Mail depends on Service Broker activated for msdb.
May 6, 2010 at 12:22 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply