SQL Server 2008 - Disabling Full Text Search

  • Hmm... I blew this one. However, MSDN does not support that "Also, sp_fulltext_database cannot (and should not) be used to enable/disable full-text search."

    Cf. description of sp_fulltext_database at http://technet.microsoft.com/en-us/library/cc721269(SQL.100).aspx#_Toc202506258.

    Seems funny that you can disable a feature but it still works.

  • Good question and a lot of great discussions. Thanks for submitting.

    http://brittcluff.blogspot.com/

  • Hmm... that's interesting.

    You can disable the full-text feature by accessing the database facets... but I didn't know that you couldn't disable the full-text SEARCH.

    [edit] That options does nothing. Now I get it. Thanks.

    Well, thank you for the question.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • Interesting question. I blew this one but learned something. Thanks!

  • DugyC (10/28/2011)


    Although, like 71% (at this time) of the others, I got this wrong because I was thinking Full-text indexing on a table can be disable/re-enabled. The question, on re-reading, is unambiguous in that it quite clearly talks about full text search on a database.

    I did not even know that it was two different thing. I thought that full-text search was a search on the full-text indexing :crazy:

    Too much to learn in SQL... but very nice to always have something to learn :satisfied:

    Thanks!

  • learned something i was not aware of....

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • Hi there,

    I have something to ask. When I stopped my SQL SERVER FULL TEXT SEARCH and I going to Start it again there was a problem? "The request failed or the service did not respond in timely fashion, consult the event log or other applicable error logs for details".

    please help me to solve this error,

    thanks

Viewing 7 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply