Changing the configuration parameters

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