"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 Thursday, April 16, 2009 10:44 AM by kemaltolga

Comments

No Comments

Leave a Comment

(required) 
(required) 
(optional)
(required)