sysusermessages

Applies to all databases. sysusermessages contains one row for each user-defined message that can be returned by the SAP ASE server.

Columns

The columns for sysusermessages are:

Name

Datatype

Description

error

varchar(1024)

Unique error number. Must be 20,000 or higher.

uid

int

Server user ID (suser_id) of the message creator.

description

varchar(1024)

User-defined message with optional placeholders for parameters.

langid

smallint null

Language ID for this message; null for us_english.

dlevel

smallint null

Stores the with_log bit, which is used to call the appropriate routine to log a message.

Indexes

  • Clustered index on error

  • Unique nonclustered index on error, langid