sp_servercaps system procedure

Syntax

sp_servercaps( sname )

Arguments

• sname – Use this CHAR(64) parameter to specify a server defined with the CREATE SERVER statement. sname must be the same server name used in the CREATE SERVER statement.

Remarks

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.

Permissions

None

Side effects

None

Example

To display information about the remote server testasa:

CALL sp_servercaps( 'testasa' );