| description | sp_fulltext_database (Transact-SQL) | ||
|---|---|---|---|
| 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.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | eeb1e151-eb00-484c-8fd1-5641e621ffc6 | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| monikerRange | =azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server SQL Database]
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.
Transact-SQL Syntax Conventions
sp_fulltext_database [@action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/14f80cf2c44be95e3fc6dbbcda170f9ccf639d83/docs/relational-databases/system-stored-procedures/] 'action'
[ @action = ] '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. |
0 (success) or 1 (failure)
None
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.
Only members of the sysadmin fixed server role and db_owner fixed database role can execute sp_fulltext_database.
DATABASEPROPERTYEX (Transact-SQL)
FULLTEXTSERVICEPROPERTY (Transact-SQL)
System Stored Procedures (Transact-SQL)