sp_servercaps system procedure

Displays information about a remote server's capabilities.

Syntax

sp_servercaps( @server_name )

Arguments

@server_name – Use this CHAR(128) parameter to specify a server defined with the CREATE SERVER statement. @server_name is the same server name used in the CREATE SERVER statement.

Results

Column	Type	Description
capid	INTEGER	The capability identifier.
capname	CHAR(128)	The name of the capability.
capvalue	CHAR(128)	The setting of the capability, usually T (true) or F (false).

Remarks

The server must be defined with the CREATE SERVER statement to use this system procedure.

This procedure displays information about a remote server's capabilities. The capability information is used to determine how much of a SQL statement can be forwarded to a remote server. The ISYSCAPABILITY system table, which lists the server capabilities, is not populated until a connection is made to the first remote server.

Standards and compatibility

Sybase – Supported by Open Client/Open Server.

Privileges

None

Side effects

None

Example

To display information about the remote server RemoteSA:

CALL sp_servercaps( 'RemoteSA' );