ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sp_servercaps system procedure

Function 

Displays information about a remote server's capabilities.

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

Syntax 

sp_servercaps servername

Permissions 

None

Side effects 

None

See also 

Accessing Remote Data

Server Classes for Remote Data Access

CREATE SERVER statement

Description 

This procedure displays information about a remote server's capabilities. Adaptive Server Anywhere uses this capability information to determine how much of a SQL statement can be forwarded to a remote server. The system tables which contain server capabilities are not populated until after Adaptive Server Anywhere first connects to the remote server. This information comes from SYSCAPABILITY and SYSCAPABILITYNAME. The servername specified must be the same servername used in the CREATE SERVER statement.

Standards and compatibility 

• Sybase    Supported by Open Client/Open Server.

Example 

• To display information about the remote server testasa issue the following stored procedure:

  sp_servercaps  testasa