The syntax for using the configuration file option with sp_configure is:
sp_configure "configuration file", 0, "subcommand", "file_name"
where:
“configuration file” – including quotes, specifies the configuration file parameter.
0 – must be included as the second parameter to sp_configure for backward compatibility.
“subcommand” – is one of the commands described below.
file_name – specifies the configuration file you want to use in conjunction with any subcommand. If you do not specify a directory as part of the file name, the directory where Adaptive Server was started is used.
