If you still want the batch file method, this might do it.

@echo off

cls

echo Installing 1 of n

osql /Sserver /Uuser /Ppassword -ddatabase -b /m-1 -iInstall01.sql -oInstall01.Err

IF ERRORLEVEL 1 GOTO er

echo Installing 2 of n

osql /Sserver /Uuser /Ppassword -ddatabase -b /m-1 -iInstall02.sql -oInstall02.Err

IF ERRORLEVEL 1 GOTO er

echo Installing 3 of n

osql /Sserver /Uuser /Ppassword -ddatabase -b /m-1 -iInstall03.sql -oInstall03.Err

IF ERRORLEVEL 1 GOTO er

...etc

GOTO ok



:er

--error reporting here

GOTO ex



:ok

--ok reporting here



:ex

 

Edited by - davidburrows on 06/10/2003 06:49:18 AM