blogs.conchango.com

Browse by Tags

• code
• dos
• Gotcha
• Microsoft
• osql
• SQL 2005

• Resetting %ERRORLEVEL% in batch file programming

  Came across a definite gotcha today in batch file programming, when I noticed that we had SET ERRORLEVEL=0 in one of our batch files. Turns out that once you set this variable explicitly then any command you run after will not be able to change the value Read More... Posted 28 February 2008 10:18 by merrick.chaffer | 0 Comments Filed under: Microsoft, code, Gotcha, batch, dos

• Returning an ERRORLEVEL to DOS prompt from OSQL utility

  After much trial and tribulation today I've finally cracked how to return a non zero exit code from a call to osql back to a dos batch file. The answer is as follows. Note the bits in bold below are most important, and the use of the single & Read More... Posted 26 November 2007 10:59 by merrick.chaffer | 1 Comments Filed under: Microsoft, SQL 2005, osql, batch, dos