| title | sp_fulltext_load_thesaurus_file (Transact-SQL) | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 03/14/2017 | |||
| ms.prod | sql-non-specified | |||
| ms.reviewer | ||||
| ms.suite | ||||
| ms.technology |
|
|||
| ms.tgt_pltfrm | ||||
| ms.topic | language-reference | |||
| f1_keywords |
|
|||
| dev_langs |
|
|||
| helpviewer_keywords |
|
|||
| ms.assetid | 73a309c3-6d22-42dc-a6fe-8a63747aa2e4 | |||
| caps.latest.revision | 22 | |||
| author | douglaslMS | |||
| ms.author | douglasl | |||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
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.
| Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version). |
Transact-SQL Syntax Conventions
sys.sp_fulltext_load_thesaurus_file lcid [ , @loadOnlyIfNotLoaded = action ]
lcid
Integer mapping the locale identifier (LCID) of the language for which you want to lade the thesaurus XML definition. To obtain the LCIDs of languages that are available on a server instance, use the sys.fulltext_languages (Transact-SQL) catalog view.
@loadOnlyIfNotLoaded = action
Specifies whether the thesaurus file is loaded into the internal thesaurus tables even if it has already been loaded. action is one of:
| Value | Definition |
|---|---|
| 0 | Load the thesaurus file regardless of whether it is already loaded. This is the default behavior of sp_fulltext_load_thesaurus_file. |
| 1 | Load the thesaurus file only if it is not yet loaded. |
None
None
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.
Use sp_fulltext_service'update_languages' to update the list of languages registered with full-text search.
Only members of the sysadmin fixed server role or the system administrator can execute the sp_fulltext_load_thesaurus_file stored procedure.
Only system administrators can update, modify, or delete thesaurus files.
The following example parses and loads the English thesaurus file.
EXEC sys.sp_fulltext_load_thesaurus_file 1033;
GO
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
FULLTEXTSERVICEPROPERTY (Transact-SQL)
System Stored Procedures (Transact-SQL)
Configure and Manage Thesaurus Files for Full-Text Search
Configure and Manage Thesaurus Files for Full-Text Search