Changing the Configuration Parameters

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