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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment