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.