SQL Server Error Msg 7686 – Cannot use a CONTAINS, FREETEXT, CONTAINSTABLE or FREETEXTTABLE construct on table or indexed view ‘%.*ls’ because none of its columns are full-text indexed. Register at least one column for full-text search using ALTER FULLTEXT INDEX statement.

In this blog post, let’s learn about the error message “7686 – Cannot use a CONTAINS, FREETEXT, CONTAINSTABLE or FREETEXTTABLE construct on table or indexed view ‘%.*ls’ because none of its columns are full-text indexed. Register at least one column for full-text search using ALTER FULLTEXT INDEX statement.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

7686 – Cannot use a CONTAINS, FREETEXT, CONTAINSTABLE or FREETEXTTABLE construct on table or indexed view ‘%.*ls’ because none of its columns are full-text indexed. Register at least one column for full-text search using ALTER FULLTEXT INDEX statement.

Reason for the Error

To be update soon…

Solution

To be update soon…