Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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