how-to run all the sql files under the current dir recursively in mssql server

@ECHO OFF

ECHO RunAll.cmd 

ECHO THIS BATCH FILE RUNS RECURSIVELY ALL THE *.SQL FILES UNDER THE CURRENT DIRECTORY 

ECHO AND OOUTPUTS OK MSGS TO AND INSTALL.LOG IN THE UPPER FOLDER 

ECHO AND OUTPUTS THE ERROR MESSAGES IN THE ERROR.LOG IN THE UPPER FOLDER

ECHO MAKE SURE SQLCMD IS IN YOUR PATH !!!

ECHO PRESS A KEY TO START RUNNING THE BATCH FILES

PAUSE

for /f %%i  in ('dir *.SQL /s /b /o') DO ECHO   %DATE% --- %TIME% RUNNING  %%i 1>>"..\install.log"&SQLCMD -U SqlLoginName -P Password -H HostName -d DataBaseName  -t 30000 -w 80 -u -p 1 -b -i %%i  -r1 1>> "..\install.log" 2>> "..\error.log" 

ECHO DONE. PRESS KEY TO VIEW THE ERROR.LOG AND THE INSTALL.LOG 

start /max ..\install.log&start /max ..\error.log

PAUSE