locked
Full Text Search Problem RRS feed

  • Question

  • Select * from candidates WHERE contains(c_resume_text,'"c++" or "houston" or "New York" or "Amsterdam"')

    I have passed nearly 400 cities to search condition.

    when i passed the 400 cities and run the query i am getting exception like

    "too many full-text columns or the full-text query is too complex to be executed"

    how can i solve that problem, please help me.

    Thnaks.

    Tuesday, June 25, 2013 6:47 PM

Answers

    • Proposed as answer by Allen Li - MSFT Friday, June 28, 2013 5:45 AM
    • Marked as answer by Kalman Toth Wednesday, July 3, 2013 12:16 AM
    Tuesday, June 25, 2013 9:56 PM
  • Consider upgrading to SQL 2008 or later. Fulltext was completely revamped and brought inside the engine in SQL Server 2008.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    • Proposed as answer by Naomi N Wednesday, June 26, 2013 3:44 AM
    • Marked as answer by Kalman Toth Wednesday, July 3, 2013 12:16 AM
    Tuesday, June 25, 2013 10:09 PM

All replies

  • Which version of SQL Server are you using?

    val it: unit=()

    Tuesday, June 25, 2013 7:59 PM

  • We are using Sql Server 2005 Version.

    Thanks,

    Tuesday, June 25, 2013 8:04 PM
    • Proposed as answer by Allen Li - MSFT Friday, June 28, 2013 5:45 AM
    • Marked as answer by Kalman Toth Wednesday, July 3, 2013 12:16 AM
    Tuesday, June 25, 2013 9:56 PM
  • Consider upgrading to SQL 2008 or later. Fulltext was completely revamped and brought inside the engine in SQL Server 2008.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    • Proposed as answer by Naomi N Wednesday, June 26, 2013 3:44 AM
    • Marked as answer by Kalman Toth Wednesday, July 3, 2013 12:16 AM
    Tuesday, June 25, 2013 10:09 PM
  • Thanks for your reply,

    But i need to do with the Sql Server 2005 only.

    If there is any alternative with out using Sql Server 2008.

    Thanks ,

    Tuesday, June 25, 2013 10:54 PM
  • Did you try the fix which I provided in my last response?

    val it: unit=()

    Wednesday, June 26, 2013 2:39 AM