A configuration file is created automatically at the time of installation. If you need to modify the configuration after installation, see sp_configure.
Use sp_configure to display or edit the configuration options. The syntax for sp_configure is:
sp_configure [service_name [, option_name [, value]]]
If no parameters are supplied, sp_configure will list all the services defined:
exec DCSERVER...sp_configure
sp_configure, with the service_name without a value, will list all of the configuration options for that service.
exec DCSERVER...sp_configure, DCSERVER0
sp_configure with the service_name (DCSRERVER0), and the option will display the current value of the option:
exec DCSERVER...sp_configure, DCSERVER0, max_users
If a value is supplied, such as “100” in the following example, sp_configure changes the option:
exec DCSERVER...sp_configure, DCSERVER0, max_users, 100
Languages and charsets cannot be displayed or edited
with sp_configure. To change these parameters,
the configuration file must be edited manually.
