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	Language; null for us_english
sqlstate	varchar(5)	SQLSTATE value for the error

Indexes

Clustered index On error, dlevel

Unique nonclustered index On error, dlevel, langid