i was trying to write a batch file that installs a program, and when there is an error return the error level - except when it has errorlevel 3010

@echo off

:SP2
Start /wait C:\SQLInstall\SP2\SQLServer2005SP2-KB921896-x86-ENU.exe /quiet /allinstances
IF (%ERRORLEVEL% == 0) goto OK
else IF (%ERRORLEVEL% == 3010) goto Restart
else goto ERROR_SP2Install

:OK
echo SP2 Installation finished.
echo Log file for SQL 2005 SP2:
echo C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log\Hotfix\Summary.txt
echo.

:Restart
echo SP2 Installation finished. Restart required.
echo Log file for SQL 2005 SP2:
echo C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log\Hotfix\Summary.txt
echo.

:ERROR_SP2Install
echo Error occurs when installating SQL server 2005 SP2. Error level: %ERRORLEVEL%
echo Log file for SQL 2005 SP2:
echo C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log\Hotfix\Summary.txt

however this doesnt works. Could anyone please help me to come up with a way that I can get the errorlevel when there is an error except when it was errorlevel 3010?

IF %ERRORLEVEL%==0 goto OK
IF %ERRORLEVEL%==3010 goto Restart
goto ERROR_SP2Install

Hi Razor,
Thanks for your help, and I have tried with your suggestion. In your suggestion it will always go to ERROR_SP2Install no matter what the errorlevel is, but my intension is going to ERROR_SP2Install only when there is a errorlevel > 0 and not 3010.

To illustrate clearer:
Case 1: errorlevel = 0
then OK
Case 2: errorlevel = 3010
then prompt for reboot
Case 3: all other errorlevel
then return the errorlevel value

is there anyway to do this, or if there is any Case command that i can use in Batch file?

Are you sure you're even getting an errorlevel?

Razor, I think an exe file always returns an errorlevel, although if it doesn't set it explicitly it may be random.

Since the original poster says that it always goes to ERROR_SP2Install, this means that his program is always returning an errorlevel other than 0 or 3010.

nic829, have you tried inserting echo %errorlevel% just before the goto commands that Razor gave you, to see exactly what error level you are getting?

Razor, I think an exe file always returns an errorlevel, although if it doesn't set it explicitly it may be random.
You would think, but START is a built-in, and not an actual program. I seem to remember it doing some funky things with errorlevel, but I could be wrong.

I think the problem is START.

Presumably, START succeeds and sets 0.

Worse yet, using START the bat goes on it's way and doesn't care what the exe is doing. I see no need for START.

=====================================
If at first you don't succeed, you're about average.

M2

The START/WAIT command is presumably there to pause the batch file until the executable it invokes returns. Otherwise, it will run the executable and the batch will continue running concurrently. When I tried it, START forwarded the errorlevel returned by the executable.