Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Error: 0x80070218 with full-text filter daemon

Author  Topic 

xrum
Yak Posting Veteran

87 Posts

Posted - 2011-09-15 : 09:51:45
I am getting the following error when trying to do a contains search on an indexed table:

Msg 30046, Level 16, State 1, Procedure sp_fulltext_service, Line 163
SQL Server encountered error 0x80070218 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.


select * from table1 where contains (MyText, 'fire')
i checked to see and my index service is running, it is also using "Local Account" to run (same as the SQL Server Agent)

when i run the sp_fulltext_service 'restart_all_fdhosts' command, i get the same error as shown above.
   

- Advertisement -