Skip to content

sp-fulltext-database-transact-sql.md

Latest commit

 

History

History
73 lines (58 loc) · 3.29 KB

sp-fulltext-database-transact-sql.md

File metadata and controls

73 lines (58 loc) · 3.29 KB

title: "sp_fulltext_database (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "system-stored-procedures" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
  • "sp_fulltext_database_TSQL"
  • "sp_fulltext_database" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "sp_fulltext_database" ms.assetid: eeb1e151-eb00-484c-8fd1-5641e621ffc6 caps.latest.revision: 45 author: "douglaslMS" ms.author: "douglasl" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"

sp_fulltext_database (Transact-SQL)

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

Has no effect on full-text catalogs in [!INCLUDEssKatmai] and later versions and is supported for backward compatibility only. sp_fulltext_database does not disable the Full-Text Engine for a given database. All user-created databases in [!INCLUDEssCurrent] are always enabled for full-text indexing.

Important

[!INCLUDEssNoteDepFutureDontUse] Use [!INCLUDEssManStudio] instead.

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
sp_fulltext_database [@action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/da4e79829135b33a03743e1edd77fc9c738f2fbb/docs/relational-databases/system-stored-procedures/] 'action'

Arguments

[ @action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/da4e79829135b33a03743e1edd77fc9c738f2fbb/docs/relational-databases/system-stored-procedures/%3C/strong>] 'action'
Is the action to be performed. action is varchar(20), and can be one of these values.

Value Description
enable Supported for backward compatibility only. Has no effect on full-text catalogs in [!INCLUDEssKatmai] and later versions.
disable Supported for backward compatibility only. Has no effect on full-text catalogs in [!INCLUDEssKatmai] and later versions.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Remarks

In [!INCLUDEssKatmai] and later versions, full-text indexing cannot be turned off. Disabling full-text indexing does not remove rows from sysfulltextcatalogs and does not indicate that full-text enabled tables are no longer marked for full-text indexing. All the full-text metadata definitions are still in the system tables.

Permissions

Only members of the sysadmin fixed server role and db_owner fixed database role can execute sp_fulltext_database.

See Also

DATABASEPROPERTYEX (Transact-SQL)
FULLTEXTSERVICEPROPERTY (Transact-SQL)
System Stored Procedures (Transact-SQL)