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