john.arnott (1/13/2010)
The 2008 BOL (link provided by Cliff) is moderately ambiguous, don't you think?The following table lists and describes the severity levels of the errors raised by the SQL Server Database Engine.
Severity level Description
0-9
Informational messages that return status information or report errors that are not severe. The Database Engine does not raise system errors with severities of 0 through 9.
[other levels described in the rest of the table...]
It's a table of "severity levels of errors raised by the ... engine." that tells us what levels 0-9 would indicate, but then says the Datebase Engine does not raise errors with those levels.
Huh?!?!?:w00t:
And then this link http://msdn.microsoft.com/en-us/library/ms164086.aspx goes on to say
"...For compatibility reasons, the Database Engine converts severity 10 to severity 0 before returning the error information to the calling application. "
So the 10's turn into 0's that are not raised??? wow...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems