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