I would like to use SqlCacheDependency to update a dataset in real-time, but we have not enabled the service broker on our production database. Could enabling the service broker have any adverse effects (performance, reliability, etc)?
migrated from stackoverflow.com Mar 12 at 14:27
Most likely Service Broker is enabled in your production database. It is enabled by default, it only gets disabled on restore in order to prevent distributed split-brains scenarios.