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
This question came from our site for professional and enthusiast programmers.
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.