How to: Enable a Database for Full-Text Indexing (SQL Server Management Studio)

New: 14 April 2006

In Microsoft SQL Server 2005, by default, all user-created databases are full-text enabled. However, there may be situations in which full-text indexing has been disabled.

To enable a database for full-text indexing

1. In Object Explorer, expand the server group, right-click the database for which you want to enable full-text indexing, and then select Properties.

2. Select the Files page, and then select Use full-text indexing.

See Also

Tasks

How to: Enable a Table for Full-Text Indexing (SQL Server Management Studio)

Other Resources

Full-Text Search Concepts

Help and Information

Getting SQL Server 2005 Assistance