sysusermessages

All databases

Description

sysusermessages contains one row for each user-defined message that can be returned by Adaptive 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

Language ID for this message; null for us_english.

dlevel

smallint

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