sysmessages

master database only

Description

sysmessages contains one row for each system error or warning that can be returned by Adaptive Server. Adaptive Server displays the error description on the user’s screen.

Columns

The columns for sysmessages are:

Name

Datatype

Description

error

int

Unique error number

severity

smallint

Severity level of error

dlevel

smallint

Reserved

description

varchar(1024)

Explanation of error with placeholders for parameters

langid

smallint null

Language; null for us_english

sqlstate

varchar(5) null

SQLSTATE value for the error

Indexes