sp_altermessage

Syntax

sp_altermessage message_id, parameter, parameter_value

Parameters

message_id – is the message number of the message to be altered. This is the number of the message as it is recorded in the error column in the sysmessages or sysusermessages system table.
parameter – is the message parameter to be altered. The maximum length is 30 bytes. The only valid parameter is with_log.
parameter_value – is the new value for the parameter specified in parameter. The maximum length is 5 bytes. Values are true and false.

Examples

Example 1 – Specifies that message number 2000 in sysmessages should be logged in the SAP ASE error log and also in the Windows Event Log (if logging is enabled):
```
sp_altermessage 2000, 'with_log', 'TRUE'
```

Usage

If the parameter_value is true, the specified message is always logged. If it is false, the default logging behavior is used; the message may or may not be logged, depending on the severity of the error and other factors. Setting the parameter_value to false produces the same behavior that would occur if sp_altermessage had not been called.

On Windows servers, sp_altermessage also enables and disables logging in the Windows Event Log.

Permissions

The permission checks for sp_altermessage differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be the database owner or a user with `own database` privilege.
Disabled	With granular permissions disabled, you must be the database owner or a user with sa_role.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect