sp_servercaps( @server_name )

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.

None

None

• SYSCAPABILITY system view
• SYSCAPABILITYNAME system view
• Remote data access
• Server classes for remote data access
• CREATE SERVER statement

To display information about the remote server RemoteSA:

CALL sp_servercaps( 'RemoteSA' );