Friday, December 12, 2008

CONTAINSTABLE query shows error "..full-text query is too complex"

Problem:
I have found that using the sql ContainsTable statement which finds too many results returns the error message "Too many full-text columns or the full-text query is too complex to be executed".

SELECT * FROM CONTAINSTABLE(mytable,myFullTextColumn,N'"Starbucks *"')

The error message really doesn't tell you that there were too many results (the real problem here ) which caused me to bang my head against the wall for a few hours.

Solution:
Run a query with more details in the search string or change your query so the search string is more specific.

No comments: