Export (0) Print
Expand All

sp_fulltext_semantic_register_language_statistics_db (Transact-SQL)

Registers a pre-populated Semantic Language Statistics database in the current instance of SQL Server.

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 SQL Server.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

EXEC sp_fulltext_semantic_register_language_statistics_db
    [ @dbname = ] ‘database_name’;
GO

[ @dbname = ] ‘database_name

Is the name of the Semantic Language Statistics database to be registered for the current instance of SQL Server. The database must already be attached. database_name is sysname, and may not be NULL.

0 (success) or 1 (failure)

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 SQL Server is a version that supports semantic processing.

  2. Checks that the instance of SQL Server does not 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 SQL Server.

  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.

For information about the Semantic Language Statistics database installed on an instance of SQL Server, query the catalog view sys.fulltext_semantic_language_statistics_database (Transact-SQL).

Permissions

Requires CONTROL SERVER permissions.

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

EXEC sp_fulltext_semantic_register_language_statistics_db @dbname = 'semanticsDb';
GO

Community Additions

ADD
Show:
© 2014 Microsoft