SQL Server error numbers

E937628

SQL Server error numbers are numeric codes that uniquely identify specific errors and conditions raised by Microsoft SQL Server, enabling precise error handling, logging, and alerting.

All labels observed (1)

Label Occurrences
SQL Server error numbers canonical 1

How this entity was disambiguated

Statements (48)

Predicate Object
instanceOf SQL Server feature
error code system
associatedWith is_event_logged flag
language id
message text
severity level
state
definedIn sys.messages catalog view
documentedIn Microsoft Learn documentation
linked to: Microsoft Learn

SQL Server Books Online
exampleErrorNumber 1205
18456
208
229
2601
2627
4060
547
8152
hasProperty numeric
unique per error definition
interpretedBy .NET SqlClient
ODBC drivers
OLE DB providers
linked to: OLE DB

client applications
maximumValue 2147483647
minimumValue 0
queriedUsing SELECT from sys.messages
raisedBy RAISERROR statement
SQL Server engine
linked to: SQL Server

THROW statement
rangePurpose 0-999 system-defined errors
1000-19999 system-defined errors
50000 and above user-defined errors
reservedRange 0-999
1000-19999
50000-2147483647
supports localization of messages
multiple languages
supportsFeature custom user-defined messages
severity-based error handling
state-based error differentiation
usedBy Microsoft SQL Server
linked to: SQL Server
usedFor alerting
error handling
error logging
identifying specific conditions
identifying specific errors

How these facts were elicited

Referenced by (1)

Full triples — surface form annotated when it differs from this entity's canonical label.

SQL Server Agent supportsAlertOn SQL Server error numbers