Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Service broker
--check whether service broker is enabled SELECT is_broker_enabled FROM sys.databases WHERE name = 'rextester' --enable broker ALTER DATABASE rextester SET ENABLE_BROKER --disable broker ALTER DATABASE rextester SET DISABLE_BROKER --in case of 'The Service Broker in database "rextester" cannot be enabled because there is already an enabled Service Broker with the same ID.' ALTER DATABASE rextester SET NEW_BROKER
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
gfhrey
tt
code
BT SQL Project
stackoverflow_mysql_demo_data
Cine Latinoamericano
Q2_5MIN
Deepak
ASSESSMENT2
emp
Please log in to post a comment.