Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Recently, and without any errors in the logs, my fulltext catalogs have stopped responding. I can't disable/delete/rename them. SSMS reports a generic error (1222) and using sql commands in the query window to remove the fulltext catalogs results in neverending executions. All the fulltext catalogs in multiple databases (same server) aren't responding. Using FREETEXT or CONTAINS times out.

what should I be checking or looking for? I'm completely out of ideas. The fulltext catalogs have been working just fine for years.

Thank you

share|improve this question
Update: SELECT FullTextServiceProperty('ResourceUsage') Causes a timeout. – Paulj Oct 8 '10 at 15:55

I know this is an old thread, but I had the same issue, and just disable full-text search, restart SS, re-enable full text search, re-start SS fixed it for me.

share|improve this answer
up vote 0 down vote accepted

Here's what 'fixed' it. Disable fulltext index service, restart server. uninstall full text service using sql 2005 installer. Restart server. Delete all fulltext catalogs for every database. Install full text service, restart server.

All this and no indication as to the nature of the error. :/

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.