sp_fulltext_database (Transact-SQL)

Initializes full-text indexing or removes all full-text catalogs from the current database. By default, all user created databases in Microsoft SQL Server 2005 are enabled for full-text indexing, unless they are created using SQL Server Management Studio. To enable a database for full-text search when creating a database by using Management Studio, see How to: Create a Database (SQL Server Management Studio).

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	Enables full-text indexing within the current database. 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.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Remarks

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. It does indicate that full-text indexing is turned off for the database and no full-text indexing activity can occur.

Permissions

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

Examples

A. Enabling a database for full-text indexing

The following example enables full-text indexing for the AdventureWorks database.

USE AdventureWorks;
GO
EXEC sp_fulltext_database 'enable';
GO

B. Removing all catalogs from a database

The following example disables full-text indexing for the AdventureWorks database.

USE AdventureWorks;
GO
EXEC sp_fulltext_database 'disable';
GO

See Also

Reference

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

Help and Information

Getting SQL Server 2005 Assistance

Change History