Contents Index Listing the remote tables on a server Working with external logins

ASA SQL User's Guide
  Accessing Remote Data
    Working with remote servers

Listing remote server capabilities


The sp_servercaps 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 passed off 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 the SYSCAPABILITY and SYSCAPABILITYNAME system tables. The servername specified must be the same servername used in the CREATE SERVER statement.

Issue the stored procedure sp_servercaps as follows:

sp_servercaps  servername

For more information, see sp_servercaps system procedure.


Contents Index Listing the remote tables on a server Working with external logins