sp_fulltext_database (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 2017 are always enabled for full-text indexing.

Important

This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. Use Management Studio instead.

||
|-|
|Applies to: SQL Server ( SQL Server 2008 through current version), SQL Database.|

Topic link icon Transact-SQL Syntax Conventions

Syntax


sp_fulltext_database [@action=] 'action'  

Arguments

[ @action=] 'action'
Is the action to be performed. action is varchar(20), and can be one of these values.

Value Description
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.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Remarks

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.

Permissions

Only members of the sysadmin fixed server role and db_owner fixed database role can execute sp_fulltext_database.

See Also

DATABASEPROPERTYEX (Transact-SQL)
FULLTEXTSERVICEPROPERTY (Transact-SQL)
System Stored Procedures (Transact-SQL)