@ECHO OFF
call Production.bat
set CHDBNAME=scheme.csviews set CHDBUSER=scheme
REM set CHDBUAUTH=<REPLACE WITH scheme PASSWORD> REM GOTO PASSWORD_VALID
:INPUTPASSWORD
set /P CHDBUAUTH=Please enter Scheme Password :
sqlcmd -S localhost -U %CHDBUSER% -P %CHDBUAUTH% -d csmaster -Q "exit" IF %ERRORLEVEL% NEQ 0 GOTO INVALIDPASSWORD
GOTO PASSWORD_VALID
:INVALIDPASSWORD
echo Password Invalid... GOTO INPUTPASSWORD
:PASSWORD_VALID
echo Password automatically set correctly