Skip to content

Instantly share code, notes, and snippets.

@sharpjs
Created June 3, 2020 17:26
Show Gist options
  • Save sharpjs/0f0f147fac2f2184e6627e561b9e3ea5 to your computer and use it in GitHub Desktop.
Save sharpjs/0f0f147fac2f2184e6627e561b9e3ea5 to your computer and use it in GitHub Desktop.
SQL Server Message Severities
// LEVEL GROUP KILLS EVENT LOG MEANING
// 0 Informational - - User-defined
// 1 Informational - - User-defined
// 2 Informational - - User-defined
// 3 Informational - - User-defined
// 4 Informational - - User-defined
// 5 Informational - - User-defined
// 6 Informational - - User-defined
// 7 Informational - - User-defined
// 8 Informational - - User-defined
// 9 Informational - - User-defined
// 10 Informational - - User-defined
// 11 Correctable - - Object does not exist
// 12 Correctable - - Inconsistent read in non-locking query
// 13 Correctable - - Transaction deadlock
// 14 Correctable - - Security-related error
// 15 Correctable - - Syntax error
// 16 Correctable - - General problem (correctable)
// 17 Uncorrectable - - Limit exceeded (configurable)
// 18 Uncorrectable - - General problem (non-correctable)
// 19 Uncorrectable Batch Yes Limit exceeded (non-configurable)
// 20 System/Fatal Connection Yes Fatal problem with this task
// 21 System/Fatal Connection Yes Fatal problem with all tasks
// 22 System/Fatal Connection Yes Table or index damaged
// 23 System/Fatal Connection Yes Database damaged
// 24 System/Fatal Connection Yes Media failure
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment