What are the system severity there in Exception raised in procedures?

849 Asked by JonathanSkinner in SQL Server , Asked on Jan 18, 2020

Severity level

Use Case

1 to 10

These are used for information messages only. These are not error

11 to 16

These errors are occured due to user issues, and that can be rectified by user itself

In this case the SQL server is going out of resources or exceeding limit in case of disk space or lock limit

It will be raised in case of nonfatal internal software

This occurs when the non-configurable internal limit exceed the limit and current running process is killed

This occurs when the current executing SQL statement gets an error, post this the current session is closed

This problem will occur on database and post that all the sessions which are running on database will get affected

This occur when the table or index got

This occurs when there is any issue in database integrity. This can rectified by DBCC command

This occurs when there is any issue in the hardware of the SQL server.

Your Answer