Skip to content

sp-fulltext-database-transact-sql.md

Latest commit

 

History

History
70 lines (55 loc) · 3.24 KB

sp-fulltext-database-transact-sql.md

File metadata and controls

70 lines (55 loc) · 3.24 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.component: "system-stored-procedures" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects 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 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/7baa3fcd57f395a8a4ed4e4b332e2e89ca4df2ec/docs/relational-databases/system-stored-procedures/] 'action'

Arguments

[ @action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/7baa3fcd57f395a8a4ed4e4b332e2e89ca4df2ec/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)