![]() ![]() The system administrator should be informed every time a message with a severity level of 18 occurs. Indicates a problem in the Database Engine software, but the statement completes execution, and the connection to the instance of the Database Engine is maintained. Indicates that the statement caused SQL Server to run out of resources (such as memory, locks, or disk space for the database) or to exceed some limit set by the system administrator. Inform your system administrator of the problem. Indicate software errors that can't be corrected by the user. Indicates general errors that can be corrected by the user. Indicates syntax errors in the Transact-SQL command. Indicates security-related errors, such as permission denied. ![]() In some cases, read operations performed by these statements could result in inconsistent data, since locks aren't taken to guarantee consistency. Indicates that the given object or entity doesn't exist.Ī special severity for queries that don't use locking because of special query hints. ![]() Indicate errors that can be corrected by the user. For compatibility reasons, the Database Engine converts severity 10 to severity 0 before returning the error information to the calling application. Informational messages that return status information or report errors that aren't severe. The Database Engine doesn't raise system errors with severities of 0 through 9. The following table lists and describes the severity levels of the errors raised by the SQL Server Database Engine. When an error is raised by the SQL Server Database Engine, the severity of the error indicates the type of problem encountered by SQL Server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |