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
bc160402152
BC3TOSQL
NOT NULL field from SELECT INTO
Generate xml
exp7
DBMS ca2
TABLE
identity
New
My data