CODEWITHSUNDEEP
sqlsql-server-2008-r2indexing
Laziale
Laziale

Reputation: 8225

creating full text index error

I am trying to create full text index but I am getting error which you can see on the printscreen below:

enter image description here

Any idea what can be the reason? Thanks, Laziale

Upvotes: 7

Views: 6614

Answers (1)

Taryn
Taryn

Reputation: 247700

This appears to be a permission issue

See answer on Server Fault:

How to get permission to create full-text index?

If you have the database-owner permission, that's all you need to do there.

Full-text indexing is an option in the SQL Server installer. You may need to go back and add the feature.

Other than that, these instructions should take care of you:

http://sqlserverpedia.com/wiki/FTS_-_How_to_use_TSQL_to_Create_Full-Text_Indexes

Upvotes: 4

Related Questions