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.
| 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 163SQL 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. |
|
|
|
|
|
Error: 0x80070218 with full-text filter daemon