I just set up SQLSERVER 2008 Express on a new machine, and on the first database on there I created a Fulltext catalog & index. When I try to use fulltext searching, I get the following error:
Msg 30053...Word breaking timed out for the full-text query string. etc.
I did some searching around and it turns out it is probably because the fdhost process is not running. Ok so I try:
exec sp_fulltext_service 'restart_all_fdhosts';
Still doesn't work. I look at the error log, and it turns out that when I run this I get a series of events that state that the full text filter daemon has started normally, stopped normally, and stopped abnormally, accompanied by Error 30089. When I look at the crawl-logs, I see the following:
Error '0x80004005' occurred during full-text index population for table or indexed view
Repeated over and over again for each row in my index. Is this a permissions thing? Any ideas? I'm running this on 64bit Vista as admin account.