Chapter 11: Accessing Catalog Information with CSPs

sp_server_info

Returns a list of attribute names and matching values for the target DBMS.

sp_server_info [attribute_id]

attribute_id: is the integer ID of the attribute. Wildcard-character search patterns are not supported.

If the attribute_id parameter is not provided, sp_server_info returns information about all attributes.
This function does not correspond to any ODBC function, but returns some of the information returned by SQLGetInfo.

sp_server_info returns a list of the requested attributes and their values.

The lengths for varchar columns shown in the result set tables are maximums; the actual lengths depend on the target database.

The following table shows the result set.

**Table 11-11: Result set for sp_server_info**
Column	Datatype	Description
ATTRIBUTE_ID	int NOT NULL	Numeric identifier of the attribute
ATTRIBUTE_NAME	varchar(60)	Attribute name
ATTRIBUTE_VALUE	varchar(254)	Attribute value