What is level and state in SQL Server?

Question

Severity level. A one- or two-digit number that indicates the severity of the error condition. State. A one- to three-digit number with a maximum value of 127 that indicates to Microsoft support engineers and developers the location in the SQL Server code that generated the message: Line number. 6 июн. 2002 г.

What does state mean in SQL?

SQLSTATE is a code which identifies SQL error conditions. It composed by five characters, which can be numbers or uppercase ASCII letters. An SQLSTATE value consists of a class (first two characters) and a subclass (last three characters).

What is level in SQL error message?

The error severity levels provide a quick reference for you about the nature of the error. The error state number is an integer value between 1 and 127; it represents information about the source that issued the error. The error message is a description of the error that occurred.

What is state in SQL error?

ERROR_STATE may be called anywhere within the scope of a CATCH block. ERROR_STATE returns the error state regardless of how many times it is run, or where it is run within the scope of the CATCH block.

What is error severity in SQL Server?

SQL ERROR SEVERITY is one of the SQL System Function used to return the severity of the error (if occurred). This ERROR SEVERITY function works within the scope of a CATCH block. If you call this function from outside the CATCH block, it will return NULL.

Expert · Answer