- February 8, 2017
- Posted by: user
- Category: Uncategorized
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]
EXEC sp_fulltext_database ‘enable’
That’s it and refresh table group and option is enable now
Hope this help