sql 2005 fulltext catalogs inaccessible

Question

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

Update: SELECT FullTextServiceProperty('ResourceUsage') Causes a timeout. — Paulj, Oct 08 '10 at 15:55

score 2 · Answer 1 · answered Nov 13 '12 at 06:11

2

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.

answered Nov 13 '12 at 06:11

Rosco

21
2

score 0 · Accepted Answer · answered Oct 08 '10 at 21:11

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. :/

sql 2005 fulltext catalogs inaccessible

2 Answers2