sp_altermessage

Description

Enables and disables the logging of a system-defined or user-defined message in the Adaptive Server error log.

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 Adaptive Server error log and also in the Windows NT Event Log (if logging is enabled):

sp_altermessage 2000, 'with_log', 'TRUE'

Usage

Permissions

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

Granular permissions enabled

With granular permissions enabled, you must be the database owner or a user with own database privilege.

Granular permissions 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:

Event

Audit option

Command or access audited

Information in extrainfo

38

exec_procedure

Execution of a procedure

  • 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

See also

System procedures sp_addmessage, sp_dropmessage