sp_displaylevel

Description

Sets or shows which Adaptive Server configuration parameters appear in sp_configure output.

Syntax

sp_displaylevel [loginame [, level]]

Parameters

loginame

is the Adaptive Server login of the user for whom you want to set or show the display level.

level

sets the display level to one of the following:

  • “basic” display level shows just the most basic configuration parameters. This level is appropriate for very general server tuning.

  • “ intermediate” display level shows configuration parameters that are somewhat more complex, as well as all the “basic” level parameters. This level is appropriate for moderately complex server tuning.

  • “ comprehensive” display level shows all configuration parameters, including the most complex ones. This level is appropriate for highly detailed server tuning.

Examples

Example 1

Shows the current display level for the user who invoked sp_displaylevel:

sp_displaylevel
The current display level for login 'sa' is 'comprehensive'.

Example 2

Shows the current display level for the user “jerry”:

sp_displaylevel jerry
The current display level for login 'jerry' is 'intermediate'.

Example 3

Sets the display level to “comprehensive” for the user “jerry”:

sp_displaylevel jerry, comprehensive
The display level for login 'jerry' has been changed to 'comprehensive'.

Usage

See the System Administration Guide for details about display levels and configuration parameters.

Permissions

Only a System Administrator can execute sp_displaylevel to set the display level for another user. Any user can execute sp_displaylevel to set and show his or her own display level.

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_configure