Run Code
|
API
|
Code Wall
|
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
Audit Example
wall
View jobs
Cinema latinoamericano
MS SQL Joins
how can i mix both querys
bc150200055
QLDT DB
SqlServer1282018
heyy