Has no effect on full-text catalogs in SQL Server 2008 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 SQL Server 2016 are always enabled for full-text indexing.
|Applies to: SQL Server (SQL Server 2008 through current version), SQL Database V12.|
sp_fulltext_database [@action=] 'action'
[ @action=] 'action'
Is the action to be performed. action is varchar(20), and can be one of these values.
|enable||Supported for backward compatibility only. Has no effect on full-text catalogs in SQL Server 2008 and later versions.|
|disable||Supported for backward compatibility only. Has no effect on full-text catalogs in SQL Server 2008 and later versions.|
0 (success) or 1 (failure)
In SQL Server 2008 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.