sp_server_info

Description

Returns a list of Adaptive Server attribute names and current values.

Syntax

sp_server_info [attribute_id]

Parameters

attribute_id

is the integer ID of the server attribute.

Examples

Example 1

sp_server_info 12

attribute_id attribute_name           attribute_value
------------ ------------------------- --------------------------
            12 MAX_OWNER_NAME_LENGTH  0

Example 2

Returns the list of server attributes, described by the mandatory rows, and their values:

sp_server_info

Usage

Permissions

Any user can execute sp_server_info.