Applies to master database only. sysmessages contains one row for each system error or warning that can be returned by the SAP ASE server. The SAP ASE 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