Full Text Search has stopped working. Why?

• mpdillon

  Hall of Fame

  Points: 3566

  More actions

  August 1, 2014 at 3:42 pm

  #291534

  Actually, the topic should have read, "How do I get Full Text Search working again?".

  There is one file in the database which contains a single field which is configured for a Full Text Search, FTS. I configured the FTS through SSMS 2008R2, although I believe the database is SQL 2005. You can view the screens and my choices in the attached PDF.

  When I query the table nothing is returned.

  1. Select * from WSWebFullTextSearch where TextOrig = 'Accessories' <== This returns results

  2. Select * from WSWebFullTextSearch where Contains(TextOrig ,'Accessories') <== This Does Not return results. Nor does it return an error.

  We have been creating/Deleting/Recreating this exact FTS for 5 years according to a document that looks very similar to the PDF attachment. Today after recreating the FTS, it stopped returning results.

  We have restart the entire server. Still the FTS will not return results or an error message.

  What is going on? And how to I fix it?

  Thanks,

  pat

• August 1, 2014 at 11:50 pm

  This was removed by the editor as SPAM