Friday, December 17, 2010

sql server - Why the Full-Text indexing option is greyed out ?

If you find Full-Text Index option grayed out on particular table you can execute following command.

Open Query window and select database for which you want to activate Full-Text Index option. After that execute below code

EXEC sp_fulltext_database 'enable'

Thanks,
Ashish Chotalia

P.S - Replace [TableName] with yours.

2 comments: