Error Severity

  • beezell (4/16/2009)


    Run this query on 2008 and tell me what you get back:

    SELECT MIN(severity),MAX(severity)

    FROM sys.sysmessages;

    That will give you your answer. Hint: 0 and 24. It's the same for RTM or SP1.

    Cheers,

    Brian

    The fact that there are no predefined messages with severity level 25 does not mean the defined range cannot include level 25 as well - and, as a matter of fact, it does!

    Best regards,
    Dietmar Weickert.

  • Yes Brian(beezell), that was the reason I have opted for 0-24 correct answer. 😀

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • For SQL 2000

    For SQL 2008

    They all say 0 - 25.

    What am i missing??????

  • The correct answer should be 0-25. BOL is slightly ambiguous as nothing is listed for 25. I have notified them of that.

    Points are awarded back and the answer changed.

  • The only thing we're missing is getting credit for the correct answer. :crazy:

    And apparently we are no longer missing that!:-P

  • You should have credit now. Let me know if that's not the case.

  • free_mascot (4/16/2009)


    Hello,

    My intention to post this question was to makes things clear.

    I do agree 0-25 is correct Answer.

    At the time of posting question I have executed

    select * from sysmessages where severity = 25 in sql server 2000 and sql server 2008 (sys.messages) and found that there are 3 entry in sql server 2000 and no entry in 2008. Hence opted for 0-24.

    Also ambiguity in BOL make me confused.

    I thank you all of you for clarifying the same.

    Appology for not scoring a point for correct answer. :pinch:

    Well sorry, but you are confusing the hell out of me. Look at your answer below:

    Correct answer: 0 to 25

    here you said that the corret answer was 0 to 25 but yet....

    Explanation: Answer is very simple and state forward; the correct answer is 0 to 24. 0-10 return informational messages, 11-15 return user-correctable errors, 17-19 are not user-correctable and should be reported to the sysadmin. 20-25 are fatal errors.

    here you said the correct answer was 0 to 24. I did the following query:

    select distinct severity from sys.messages order by severity desc and found that there were severities 0 to 24 yet I did not get my point and got the message that my answer was wrong.

    Not much worried about the point but think that people should before the post questions make sure of their facts.

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • I find the question and the answer explanation hilarious. Question writing is not as easy it is would seem. 🙂

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply