Full text Search - Contains Results Incorrect?

• Hughesy

  Ten Centuries

  Points: 1399

  More actions

  June 28, 2008 at 9:37 am

  #184067

  Hello

  I am getting some strange results after creating a full text index on a column.

  The results returned from a CONTAINS search against the column first found ZERO results when I knew that this was incorrect I REBUILT the full text search. I then got back 7 results and after re-building again I received 17 records.

  What is going on here? Can anyone help? I just don't get it. Surely when an full text search is created on a column, I should not have to keep re-building it? There are no errors when the search is created or when the results are returned. There are also no errors in the event log.

  Can anyone advise?

  Thanks in advance.

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  July 25, 2008 at 5:37 am

  #848315

  How is the full-text catalog populated (i.e. automatically or manually)?

  How many rows should have been returned by the query?

  Have you also checked the FTS crawl log?

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com