Error with Linked Field | CONTAINS or FREETEXT predicate on table or indexed view not full-text indexed

If you encounter an error while changing a linked field that references “CONTAINS or FREETEXT predicate on table or indexed view not full-text indexed” then you likely need to check that

  • Search Fields of your Linked Field are Full Text Index
  • Full Text Indexed Checkbox on the Linked Field’s Relationship is not checked if any of the search fields are not full text indexed

The latter can happen when you re unable to enable full text indexing on a field when you have more than 1 million records

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s