sp_fulltext_database (Transact-SQL)
Applies to: 
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 SQL Server are always enabled for full-text indexing.
Important
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Management Studio instead.
Transact-SQL syntax conventions
Syntax
sp_fulltext_database [ @action = ] 'action'
[ ; ]
Arguments
[ @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. |
Return code values
0 (success) or 1 (failure).
Result set
None.
Remarks
In SQL Server 2008 (10.0.x) 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.
Permissions
Only members of the sysadmin fixed server role and db_owner fixed database role can execute sp_fulltext_database.