Admin User     Feb,08 2017

Full Text Option Is Greyed Out in MSSql 2008

Today I was trying to setup fulltext indexing on one of my database table. I have finish with creating fulltext catelog and tried to right click on table to create fulltext index but option was greyed out and there is no way to create index.

This is becuse Full-text index was diabled at database level, you can enable it by running below statement.

 

use [mydatabase name]
go
EXEC sp_fulltext_database 'enable'

 

That's it and refresh table group and option is enable now

Hope this help