Altering a server definition

You can alter a existing server definition to change the version of the data source that the remote server uses.

Before you begin

Ensure that the authorization ID that issues the ALTER SERVER statement has either SYSADM or DBADM authority on the federated database.

See Restrictions on altering server definitions.

Procedure

Use one of the following methods:

  • Command line:

    Issue the ALTER SERVER statement.

    Example: You are working with a server definition for a Microsoft SQL Server Version 6.5 data source. The name that you assigned the server in the CREATE SERVER statement is SQLSVR_ASIA. If the Microsoft SQL Server is upgraded to Version 7.0, the following statement alters the server definition:
    ALTER SERVER SQLSVR_ASIA VERSION 7
  • Web console:
    1. Click Administer > Remote Tables.
    2. Click a remote server name.
    3. Click Alter.