The stored procedure sp_configure displays all the configuration values when it is used without an argument. When used with an option name and a value, the server resets the configuration value of that option in the system tables.
See the System Administration Guide for a complete discussion of sp_configure with syntax options.
To see the Component Integration Services options enter:
sp_configure "Component Integration Services"
To change the current value of a configuration parameter, execute sp_configure as follows:
sp_configure "parameter", value
