Altering the data source version in a server definition
You can alter an existing server definition to change the version of the data source that the remote server uses.
Before you begin
The authorization ID issuing the ALTER SERVER statement must include either SYSADM or DBADM authority on the federated database.
About this task
Restrictions
Procedure
To alter a server definition from the 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