SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

sp_fulltext_semantic_unregister_language_statistics_db (Transact-SQL)

SQL Server 2012

Unregisters an existing Semantic Language Statistics database from the current instance of SQL Server 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

Transact-SQL
Copy 
EXEC sp_fulltext_semantic_unregister_language_statistics_db;
GO

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

0 (success) or 1 (failure)

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

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

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 unregister the Semantic Language Statistics database by calling sp_fulltext_semantic_unregister_language_statistics_db.

Transact-SQL
Copy 
EXEC sp_fulltext_semantic_unregister_language_statistics_db;
GO
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.