| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_fulltext_database (Transact-SQL) |
sp_fulltext_database is included for backward compatibility only. |
markingmyname |
maghan |
randolphwest |
07/07/2023 |
sql |
system-objects |
reference |
|
|
|
=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.