Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Error

Error

Scheduled Pinned Locked Moved Database
sharepointdatabasesql-serversysadminhelp
6 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • U Offline
    U Offline
    User 11127370
    wrote on last edited by
    #1

    HI, EveryBody 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. when i run the sp_fulltext_service 'restart_all_fdhosts' command, i get the same error as shown above.

    CHill60C Richard DeemingR 2 Replies Last reply
    0
    • U User 11127370

      HI, EveryBody 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. when i run the sp_fulltext_service 'restart_all_fdhosts' command, i get the same error as shown above.

      CHill60C Offline
      CHill60C Offline
      CHill60
      wrote on last edited by
      #2

      Did you restart the SQL Server instance?

      1 Reply Last reply
      0
      • U User 11127370

        HI, EveryBody 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. when i run the sp_fulltext_service 'restart_all_fdhosts' command, i get the same error as shown above.

        Richard DeemingR Offline
        Richard DeemingR Offline
        Richard Deeming
        wrote on last edited by
        #3

        You're still getting this error four years after you first posted it? :omg:

        http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=165443[^]:

        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. Edited by - xrum on 09/15/2011 09:52:27


        "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

        "These people looked deep within my soul and assigned me a number based on the order in which I joined" - Homer

        CHill60C M 2 Replies Last reply
        0
        • Richard DeemingR Richard Deeming

          You're still getting this error four years after you first posted it? :omg:

          http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=165443[^]:

          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. Edited by - xrum on 09/15/2011 09:52:27


          "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

          CHill60C Offline
          CHill60C Offline
          CHill60
          wrote on last edited by
          #4

          *sniff* *sniff* ... methinks there is the odour of urine extraction around here somewhere. He's had me for a sucker :mad:

          1 Reply Last reply
          0
          • Richard DeemingR Richard Deeming

            You're still getting this error four years after you first posted it? :omg:

            http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=165443[^]:

            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. Edited by - xrum on 09/15/2011 09:52:27


            "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

            M Offline
            M Offline
            Mycroft Holmes
            wrote on last edited by
            #5

            Wow did you remember this from the first time he asked? Elephant something (in the original use of the word)

            Never underestimate the power of human stupidity RAH

            Richard DeemingR 1 Reply Last reply
            0
            • M Mycroft Holmes

              Wow did you remember this from the first time he asked? Elephant something (in the original use of the word)

              Never underestimate the power of human stupidity RAH

              Richard DeemingR Offline
              Richard DeemingR Offline
              Richard Deeming
              wrote on last edited by
              #6

              No, my memory's not *that* good! :-O It just came up on a Google search for the error message.


              "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

              "These people looked deep within my soul and assigned me a number based on the order in which I joined" - Homer

              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups