SQL 2005 Full text index problem

• brian_winzeler

  Mr or Mrs. 500

  Points: 564

  More actions

  December 21, 2010 at 1:58 pm

  #157364

  Today I've come upon a full text catalog error that has me baffled. All queries against my full text indexes such as: SELECT * FROM tbl_foo WHERE CONTAINS(col_desc, 'Random text string'), produces the following error:

  Msg 7624, Level 16, State 3, Line 1

  Full-text catalog 'tbl_foo' is in an unusable state. Drop and re-create this full-text catalog.

  However, this next query produces the desired results:

  SELECT * FROM tbl_foo WHERE CONTAINS(col_desc, '"*Random text string*"').

  I have re-created the full text catalog and rebuilt it on multiple databases to no avail. This only happens on this one box... but to every database. I compared server settings to my production box and there was no differences. The first query works like it's supposed to on my other production boxes. What could be causing this?

• HarryG24

  Old Hand

  Points: 339

  More actions

  April 18, 2013 at 11:49 am

  #1607928

  Hi,

  I know its been a while since you had this error. But can you please tell me how you fixed it.

  I am facing the sam error now.

  Thanks