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 Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide: Volume 1, and the Component Integration Services Users Guide.
