Scenario:- Generally For activating some configurations maintenance mode is required .
This can be done in two ways
1) From LCS
2) SQL procedure
We discuss here 2 step
SQL procedure
Step1) First of all , run this script
select * from SQLSYSTEMVARIABLES where PARM = 'CONFIGURATIONMODE'
result :- value field 0=normal and 1= maintenance mode
Step2) To turn into maintenance mode run the below script
update SQLSYSTEMVARIABLES SET VALUE = 0 where PARM = 'CONFIGURATIONMODE'
Step3) DO iisreset in commandprompt
Step4) do db sync
visualstudio>extensions>syncorinzedb
Step 5) Now after db sync env will be in maintence mode
Note:- after activating and put maintenance mode back to normal by following same procedure but with 0
