configuration file

Summary information

Default value

0 (off)

Range of values

One of: 0, verify, read, write, or restore

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

General Information

configuration file specifies the location of the configuration file currently in use. See “Using sp_configure with a configuration file” for a complete description of configuration files.

In sp_configure output, the “Run Value” column displays only 10 characters, so the output may not display the entire path and name of your configuration file.