Chapter 12: Retrieving Information with System Procedures

sp_helpserver

Description

Provides the user with a report containing the following 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 an access service is associated

Syntax

sp_helpserver

Parameters

This procedure does not allow parameters.

Usage

Results

The following table 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

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF