Initializes full-text indexing or removes all full-text catalogs from the current database.
sp_fulltext_database [@action =] 'action'
Value | Description |
---|---|
enable | Enables full-text indexing within the current database. If full-text catalogs already exist, this procedure drops all full-text catalogs, re-creates any full-text indexing indicated in the system tables, and marks the database as full-text enabled. This action does not cause index population to begin; an explicit start_full or start_incremental on each catalog must be issued using sp_fulltext_catalog to populate or repopulate the full-text index. |
disable | Removes all full-text catalogs in the file system for the current database and marks the database as being disabled for full-text indexing. This action does not change any full-text index metadata at the full-text catalog or table level. |
0 (success) or 1 (failure)
None
Disabling full-text indexing does not remove rows from sysfulltextcatalogs and does not mean 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. It does mean that full-text indexing has been turned off for the database and no full-text indexing activity can occur.
Only members of the db_owner fixed database role can execute sp_fulltext_database.
This example enables full-text indexing for the Northwind database.
USE Northwind
EXEC sp_fulltext_database 'enable'
DATABASEPROPERTY | System Stored Procedures |
FULLTEXTSERVICEPROPERTY |