in

ASP.NET Weblogs

Tolga Koseoglu

"Full text index" optioni is grayed on database table

Here are the steps to enable this

  1. Make sure the SQL Server FTS is running
    1. Click Start, Programs, Microsfot SQL Server 2005, Configuration Tools, SQL Server Configuration Manager
    2. Select SQL Server 2005 Services
    3. Find "SQL Server FulltextSearch"
    4. Enable/Start the service
  2. Go back to SSMS (Management Studio) and open a query window. Execute the following query...
                                  
use [database name]

exec sp_fulltext_database 'enable'

 

Good luck...

Published Apr 16 2009, 10:44 AM by kemaltolga
Filed under:

Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add

About kemaltolga

Born in Ankara, Turkey. Raised in Germany. Recruited for the Track & Field Team at Texas A&M University in College Station, TX, in January 2000. NCAA champion in 2001 (Discus). Work for design firm in southern California. Married with two daughters.
Terms of Use