Please start any new threads on our new site at 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 

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 -