Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

just migrated to sql server 2008 for some reason the enable full text checkbox for all my databases are grayed out. any idea why?

i do not see full text in services just full text filter daemon launcher

share|improve this question
up vote 0 down vote accepted

Did you install the fulltext feature during the migration? Its an optional component so by default will not be installed. You can check if fulltext is installed by querying the IsFullTextInstalled SERVERPROPERTY.

Also, how did you migrate? There are specific steps for full-text upgrade that have to be done, see Full-Text Search Upgrade.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.