Skip to content

sp-fulltext-semantic-register-language-statistics-db-transact-sql.md

Latest commit

 

History

History
91 lines (58 loc) · 3.76 KB

sp-fulltext-semantic-register-language-statistics-db-transact-sql.md

File metadata and controls

91 lines (58 loc) · 3.76 KB
title sp_fulltext_semantic_register_language_statistics_db (Transact-SQL)
description Registers a pre-populated Semantic Language Statistics database in the current instance of SQL Server.
author markingmyname
ms.author maghan
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sp_fulltext_semantic_register_language_statistics_db
sp_fulltext_semantic_register_language_statistics_db_TSQL
helpviewer_keywords
sp_fulltext_semantic_register_language_statistics_db
dev_langs
TSQL

sp_fulltext_semantic_register_language_statistics_db (Transact-SQL)

[!INCLUDE SQL Server]

Registers a pre-populated Semantic Language Statistics database in the current instance of [!INCLUDE ssNoVersion].

You can initiate semantic extraction only after you have attached this language statistics database and registered it by using this stored procedure. You only need to perform this task once for each instance of [!INCLUDE ssNoVersion].

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_fulltext_semantic_register_language_statistics_db [ @dbname = ] N'dbname'
[ ; ]

Arguments

[ @dbname = ] N'dbname'

The name of the Semantic Language Statistics database to be registered for the current instance of [!INCLUDE ssNoVersion]. The database must already be attached. @dbname is sysname, and can't be NULL.

Return code values

0 (success) or 1 (failure).

Result set

None.

Remarks

The Semantic Language Statistics database contains language-related statistics that are required for semantic processing of textual content.

sp_fulltext_semantic_register_language_statistics_db performs the following steps:

  1. Checks that the instance of [!INCLUDE ssNoVersion] is a version that supports semantic processing.

  2. Checks that the instance of [!INCLUDE ssNoVersion] doesn't already have a Semantic Language Statistics database defined.

  3. Checks that the database is a valid Semantic Language Statistics database.

  4. Sets permissions on the Semantic Language Statistics database to restrict access to the database by users.

  5. Inserts the metadata that defines the name of the Semantic Language Statistics database for the instance of [!INCLUDE ssNoVersion].

  6. Inserts the metadata that defines the mappings between the installed Semantic Language Statistics database and the internal Language Model tables.

  7. Checks to ensure that the database is ready to be used.

For more information, see Install and Configure Semantic Search.

Metadata

For information about the Semantic Language Statistics database installed on an instance of [!INCLUDE ssNoVersion], query the catalog view sys.fulltext_semantic_language_statistics_database.

Permissions

Requires CONTROL SERVER permissions.

Examples

The following example shows how to register the Semantic Language Statistics database by calling sp_fulltext_semantic_register_language_statistics_db.

EXECUTE sp_fulltext_semantic_register_language_statistics_db @dbname = 'semanticsDb';
GO

Related content