Error Severity

Question

Error Severity

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

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

Dietmar Weickert SSCrazy Points: 2398 More actions · Answer 1

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.

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

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."

robert.kosik Valued Member Points: 62 More actions · Answer 3

For SQL 2000

For SQL 2008

They all say 0 - 25.

What am i missing??????

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 4

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.

LostAccount SSCarpal Tunnel Points: 4951 More actions · Answer 5

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

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

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 6

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

Manie Verster SSCertifiable Points: 7152 More actions · Answer 7

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)

DPhillips-731960 Hall of Fame Points: 3904 More actions · Answer 8

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