sp_helpserver

Description

Provides the user with a report containing these rows of information:

Row 1: the version of Open Server currently in use
Row 2: the version of DirectConnect server currently in use
Row 3: the version of the DB2 access service library currently in use
Row 4: the version of the DBMS with which a DB2 access service is associated

Syntax

sp_helpserver

Parameters

This procedure does not allow parameters.

Usage

Results

Table 12-4 shows the sp_helpserver result set.

**Table 12-4: Result set for sp_helpserve**
Column name	Datatype	Description
SERVER_PROPERTY	varchar(32)	Server property name
PROPERTY_VALUE	varchar(32)	Server property value