Skip to content

sp-fulltext-database-transact-sql.md

Latest commit

 

History

History
72 lines (56 loc) · 3.31 KB

sp-fulltext-database-transact-sql.md

File metadata and controls

72 lines (56 loc) · 3.31 KB
title sp_fulltext_database (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-non-specified
ms.reviewer
ms.suite
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 jhubbard

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.
Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version), [!INCLUDEsqldbesa].

Topic link icon Transact-SQL Syntax Conventions

Syntax

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

Arguments

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