master database only
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.
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 |
Clustered index on error, dlevel
Nonclustered index on error, dlevel, langid
