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
Negociosj
SQL CASE WHEN
Dynamic Sql command with output variable
Query to remove the string between two indexes of delimiters
Student.sql
SALESPEOPLE
SS my sql server 2014 4/7
Remove duplicates with in 10 min
JSON with No root node - Format from XML output - SQL
student table create