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.
Table 6-14 shows the 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 |
