Displays or changes Enhanced Full-Text Search engine configuration parameters.
sp_text_configure server_name [, config_name [, config_value]]
is the name of the Enhanced Full-Text Search engine.
is the name of the configuration parameter to be displayed or modified.
is the value you assign to the configuration parameter.
sp_text_configure KRAZYCAT, backdir, "/data/backup"
Changes the backup destination directory to /data/backup.
sp_text_configure KRAZYCAT, backdir
Displays the backup destination directory.
When you execute sp_text_configure to modify a dynamic parameter:
The configuration and run values are updated.
The configuration file is updated.
The change takes effect immediately.
When you execute sp_text_configure to modify a static parameter:
The configuration value is updated.
The configuration file is updated.
The change takes effect only when you restart the Enhanced Full-Text Search engine.
When issued with no parameters, sp_text_configure displays a report of all Enhanced Full-Text Search engine configuration parameters and their current values.
If you specify the config_name parameter, but omit the config_value parameter, sp_text_configure displays the report for the configuration parameter specified.
For information on the individual configuration parameters, see “Modifying the configuration parameters”.
Configuration value cannot be specified without a configuration option.
This procedure is not supported against remote server ‘server_name.’
sp_text_configure failed – possible invalid configuration option ‘config_name.’
Any user can execute sp_text_configure.
