Add
-m-1
to your osql parameters
Create your batch file like this
CALL batchfile.bat servername databasename scriptname1.sql
IF ERRORLEVEL 1 GOTO ER
CALL batchfile.bat servername databasename scriptname2.sql
IF ERRORLEVEL 1 GOTO ER
CALL batchfile.bat servername databasename scriptname3.sql
IF ERRORLEVEL 1 GOTO ER
GOTO EX
:ER
ECHO Error
:EX
Far away is close at hand in the images of elsewhere.
Anon.