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
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