STRESS.CMD

 

@echo offREM Check for too few or too many parms and errorIF (%1)==() GOTO ERRORIF NOT (%9)==() GOTO ERRORREM Set some default valuesSET ggmask=%1SET ggtimes=1SET ggwait=NOSET ggserv=(local)SET gguser=-ESET ggwaitparm=/NORMALSET ggwin=NORMALSET ggout=YESREM Move parameters to variablesIF NOT (%2)==() SET ggtimes=%2IF NOT (%3)==() SET ggwait=%3IF NOT (%4)==() SET ggwin=%4IF NOT (%5)==() SET ggout=%5IF NOT (%6)==() SET ggserv=%6IF NOT (%7)==() SET gguser=%7REM Set this to empty if not suppliedSET ggpwd=%8REM Set this to emptySET ggoutparm=%9REM Further process some of the parametersIF NOT (%ggpwd%)==() SET ggpwd=-P%ggpwd%IF /i %ggwait%==YES SET ggwaitparm=/WAITIF NOT %gguser%==-E SET gguser=-U%gguser%IF /i %ggout%==YES SET ggoutparm=-o%%~nf.OUTREM Run the script(s) using a nested loopREMREM The inner loop iterates through the files matching the mask and runs themREM The outer loop executes the inner loop the number of times specifiedFOR /L %%i in (1,1,%ggtimes%) DO FOR %%f IN (%ggmask%) DO START "%%f"      %ggwaitparm% /%ggwin% OSQL.EXE -S%ggserv% %gguser% %ggpwd% -i%%f      %ggoutparm%GOTO NOERROR:ERRORecho You must specify a script to runSET ERRORLEVEL=1ECHO STRESS.CMDECHO .ECHO Runs specified Transact-SQL script(s) multiple times simultaneouslyECHO .ECHO Copyright (c) 1992, Ken Henderson. All rights reserved.ECHO Based on my code in User-to-User, PC Magazine, March 26, 1991.ECHO .ECHO USAGE: STRESS script [N] [wait] [windowstyle] [saveoutput] [server][user] [password]ECHO .ECHO where:ECHO   script = the script or mask you want to runECHO   N = the number of times you want to run it (default 1)ECHO   wait = YES to wait for each script to finish before running next(default NO)ECHO   windowstyle = type of window to create for each script execution:ECHO .ECHO          MIN = minimized MAX = maximized B = no window NORMAL = normalwindowECHO .ECHO   saveoutput = YES to save output to file using -o OSQL parameter(default YES)ECHO   server = the server to run it on (default (local) )ECHO   user = your SS user name (default - use trusted connection)ECHO   password = your SS password (default - use trusted connection):NOERROR