| title | sp_fulltext_database (Transact-SQL) | ||
|---|---|---|---|
| description | sp_fulltext_database is included for backward compatibility only. | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.reviewer | randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
||
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]
This is supported for backward compatibility only. sp_fulltext_database doesn't disable the Full-Text Engine for a given database. All user-created databases in [!INCLUDE ssnoversion-md] are always enabled for full-text indexing.
Important
[!INCLUDE ssNoteDepFutureAvoid] Use [!INCLUDE ssManStudio] instead.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_fulltext_database [ @action = ] 'action'
[ ; ]
The action to be performed. @action is varchar(20), and can be one of these values.
| Value | Description |
|---|---|
| enable | Supported for backward compatibility only. It rebuilds all full-text catalogs of the database if the previous state of full-text is disabled. |
| disable | Supported for backward compatibility only. |
0 (success) or 1 (failure).
None.
In [!INCLUDE sql2008-md] and later versions, full-text indexing can't be turned off. Disabling full-text indexing doesn't remove rows from sysfulltextcatalogs and doesn't 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.