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.
Showing posts with label full-text search. Show all posts
Showing posts with label full-text search. Show all posts
Friday, December 12, 2008
Subscribe to:
Posts (Atom)