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.

  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.

Community Additions