Skip to content

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

Latest commit

 

History

History
76 lines (55 loc) · 3.36 KB

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

File metadata and controls

76 lines (55 loc) · 3.36 KB
title sp_fulltext_semantic_unregister_language_statistics_db (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology system-objects
ms.topic language-reference
f1_keywords
sp_fulltext_semantic_unregister_language_statistics_db_TSQL
sp_fulltext_semantic_unregister_language_statistics_db
dev_langs
TSQL
helpviewer_keywords
sp_fulltext_semantic_unregister_language_statistics_db
ms.assetid 1426ca4a-9a76-489e-98da-8f6d13ff9732
author MikeRayMSFT
ms.author mikeray

sp_fulltext_semantic_unregister_language_statistics_db (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Unregisters an existing Semantic Language Statistics database from the current instance of [!INCLUDEssNoVersion] and deletes any associated metadata.

This statement does not detach the database or remove the physical database file from the file system. After you unregister the database, you can detach it and delete the physical database file.

Topic link icon Transact-SQL Syntax Conventions

Syntax

EXEC sp_fulltext_semantic_unregister_language_statistics_db;  
GO

Arguments

This procedure does not require any arguments. Since an instance of [!INCLUDEssNoVersion] only has one semantic language statistics database, it is not necessary to identify the database.

Return Code Value

0 (success) or 1 (failure)

Result Set

None.

General Remarks

When a Semantic Language Statistics database is unregistered, all the metadata associated with it is also removed.

sp_fulltext_semantic_unregister_language_statistics_db performs the following steps:

  1. Checks that there are no semantic populations in progress for the current instance of [!INCLUDEssNoVersion].

  2. Removes all metadata associated with the specified Semantic Language Statistics database.

For more information, see Install and Configure Semantic Search.

Metadata

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

Security

Permissions

Requires CONTROL SERVER permissions.

Examples

The following example shows how to unregister the Semantic Language Statistics database by calling sp_fulltext_semantic_unregister_language_statistics_db.

EXEC sp_fulltext_semantic_unregister_language_statistics_db;  
GO

See Also

Install and Configure Semantic Search