Skip to content

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

Latest commit

 

History

History
79 lines (52 loc) · 3 KB

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

File metadata and controls

79 lines (52 loc) · 3 KB
title sp_fulltext_semantic_unregister_language_statistics_db (Transact-SQL)
description Unregisters an existing Semantic Language Statistics database from 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_unregister_language_statistics_db_TSQL
sp_fulltext_semantic_unregister_language_statistics_db
helpviewer_keywords
sp_fulltext_semantic_unregister_language_statistics_db
dev_langs
TSQL

sp_fulltext_semantic_unregister_language_statistics_db (Transact-SQL)

[!INCLUDE SQL Server]

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

This statement doesn't 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.

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

Syntax

sp_fulltext_semantic_unregister_language_statistics_db
[ ; ]

Arguments

This procedure doesn't require any arguments. Since an instance of [!INCLUDE ssNoVersion] only has one semantic language statistics database, it isn't necessary to identify the database.

Return code values

0 (success) or 1 (failure).

Result set

None.

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 [!INCLUDE ssNoVersion].

  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 [!INCLUDE ssNoVersion], query the catalog view sys.fulltext_semantic_language_statistics_database.

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.

EXECUTE sp_fulltext_semantic_unregister_language_statistics_db;
GO

Related content