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.

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.

select distinct severity from sys.messages order by severity desc