Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You can't use -V-3, the lowest value is -V1. In Combination with -b you should get the desired result. The value "ERRORLEVEL" will be set to 1 only if the severity is HIGHER than the value of -V.</p> <p>My best guess is (not tested):</p> <pre><code>sqlcmd.exe -X1 -b -S "[ValidServer]" -d "[ValidDatabase]" -t 5 -i "C:\test\ScriptThatRunsLongerThan5Seconds.sql" -E -V1 </code></pre> <p>And then try:</p> <pre><code>echo %ERRORLEVEL% </code></pre> <p>The relevant part is:</p> <blockquote> <p>The value that is returned to the DOS ERRORLEVEL variable is 1 when the SQL Server error message has a severity level greater than 10; otherwise, the value returned is 0. If the -V option has been set in addition to -b, sqlcmd will not report an error if the severity level is lower than the values set using -V</p> </blockquote> <p>From <a href="http://technet.microsoft.com/en-us/library/ms162773.aspx" rel="nofollow">http://technet.microsoft.com/en-us/library/ms162773.aspx</a></p> <blockquote> <p>-b</p> <p>Specifies that sqlcmd exits and returns a DOS ERRORLEVEL value when an error occurs. The value that is returned to the DOS ERRORLEVEL variable is 1 when the SQL Server error message has a severity level greater than 10; otherwise, the value returned is 0. If the -V option has been set in addition to -b, sqlcmd will not report an error if the severity level is lower than the values set using -V. Command prompt batch files can test the value of ERRORLEVEL and handle the error appropriately. sqlcmd does not report errors for severity level 10 (informational messages).</p> <p>If the sqlcmd script contains an incorrect comment, syntax error, or is missing a scripting variable, ERRORLEVEL returned is 1.</p> <p>-m error_level</p> <p>Controls which error messages are sent to stdout. Messages that have a severity level greater than or equal to this level are sent. When this value is set to -1, all messages including informational messages, are sent. Spaces are not allowed between the -m and -1. For example, -m-1 is valid, and -m -1 is not.</p> <p>This option also sets the sqlcmd scripting variable SQLCMDERRORLEVEL. This variable has a default of 0.</p> <p>-V error_severity_level</p> <p>Controls the severity level that is used to set the ERRORLEVEL variable. Error messages that have severity levels greater than or equal to this value set ERRORLEVEL. Values that are less than 0 are reported as 0. Batch and CMD files can be used to test the value of the ERRORLEVEL variable.</p> </blockquote>
    singulars
    1. This table or related slice is empty.
    1. POHow do I handle sqlcmd.exe "Timeout expired" message, which doesn't appear to be an error?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USStefan M
    1. USStefan M
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I handle sqlcmd.exe "Timeout expired" message, which doesn't appear to be an error?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThank you for your answer. You are right about -V-3 being incorrect, and my previous tests did not have a combination of -b and -V1. I just attempted that combination with no dice. Still exit code 0 and Standard Ouput "Timeout expired\r\n". Thank you for trying though.
      singulars
      1. PO
      1. USJustinP8
    2. COThe `ERRORLEVEL` is empty as well?
      singulars
      1. PO
      1. USStefan M
    3. COI'm not sure actually. I updated the question mentioning I'm calling sqlcmd.exe via C# using System.Diagnostics.Process.
      singulars
      1. PO
      1. USJustinP8
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload