Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Error Severity Expand / Collapse
Author
Message
Posted Thursday, April 16, 2009 10:13 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:00 PM
Points: 31,181, Visits: 15,627
You should have credit now. Let me know if that's not the case.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #698633
Posted Thursday, April 16, 2009 11:29 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 5:21 AM
Points: 1,205, Visits: 923
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.


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.


Manie 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)
Post #698723
Posted Thursday, April 16, 2009 9:19 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 10, 2012 6:08 PM
Points: 1,156, Visits: 801
I find the question and the answer explanation hilarious. Question writing is not as easy it is would seem.
Post #699097
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse