Causes the server instance to parse and load the data from the thesaurus file that corresponds to the language whose LCID is specified. This stored procedure is useful after updating a thesaurus file. Executing sp_fulltext_load_thesaurus_file causes recompilation of full-text queries that use the thesaurus of the specified LCID.
Thesaurus files are automatically loaded by full-text queries that use the thesaurus. To avoid this first-time performance impact on full-text queries, we recommend that you execute sp_fulltext_load_thesaurus_file.
When compiling a full-text query that requires a thesaurus for a given language, the Full-Text Engine loads the thesaurus file only if it has not yet been loaded.
Use sp_fulltext_service'update_languages' to update the list of languages registered with full-text search.
Example A: Load a thesaurus file even if it is already loaded
The following example parses and loads the English thesaurus file:
EXEC sys.sp_fulltext_load_thesaurus_file 1033; GO
Example B: Load a thesaurus file only if it is not yet loaded
The following example parses and loads the Arabic thesaurus file, unless it is already loaded:
EXEC sys.sp_fulltext_load_thesaurus_file 1025, @loadOnlyIfNotLoaded = 1; GO