(Enhanced version only)
Displays or changes Full-Text Search engine configuration parameters.
sp_text_configure server_name [, config_name [, config_value]]
– is the name of the 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 Full-Text Search engine
When issued with no parameters, sp_text_configure displays a report of all Full-Text Search engine configuration parameters and their current values.
If the config_name parameter is specified, but the config_value parameter is omitted, 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.
