You can use alter table to modify a remote table using Component Integration Services (CIS). Before you modify a remote table, make sure that CIS is running by entering:
sp_configure "enable cis"
If CIS is enabled, the output of this command is “1.” By default, CIS is enabled when you install Adaptive Server.
See the System Administration Guide for information about enabling configuration parameters. See the Component Integration Services User’s Guide for information about using CIS.
