SQL Server 2008 - Disabling Full Text Search

  • Nakul Vachhrajani

    SSChampion

    Points: 10215

    Comments posted to this topic are about the item SQL Server 2008 - Disabling Full Text Search

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com
    Be courteous. Drive responsibly.

    Follow me on
    Twitter: @sqltwins

  • M&M

    SSC-Insane

    Points: 21699

    Good question, never heard about this. Thanks.

    M&M

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Great question, I didn't know this was the default.

    Learned something on a Friday 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • michael.kaufmann

    SSCrazy

    Points: 2816

    Thanks for the question.

    However, I'm curious about the discussion to follow, as I personally find the wording ambiguous 😉

    In order to be able to carry out a (plain English) full text search, you have to set up a (MSDN speak) full-text catalog with at least one full-text index (see MSDN Getting Started with Full-Text Search).

    In plain English: While any database created in SQL Server 2008 (and higher) is (MSDN speak) full-text enabled (please note: no search), use of this feature can only be made after performing certain steps. And if you drop the full-text index, no (plain English) full text search can be carried out (what I'd say qualifies as 'full text search is disabled').

    So thanks again for the question and pointing towards the interesting wording approach by MSDN. 😎

  • Rhox

    Hall of Fame

    Points: 3462

    Nice question, glad I received a point 🙂

    But you can disable or Re-enable a Table for Full-Text Indexing 🙂

    http://technet.microsoft.com/en-us/library/ms142536.aspx

  • This was removed by the editor as SPAM

  • DugyC

    Hall of Fame

    Points: 3804

    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.

    Ah well... got me 😛

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • ipounder

    SSCommitted

    Points: 1541

    Good question, however the answer is a bit pedantic, so I'm going to be a bit pedantic in my comment. Whilst you can't disable full text search at the database level, you can achieve this in effect by disabling it at the table level, so if you do it on all tables, it is removed, is it not?:-)

  • DugyC

    Hall of Fame

    Points: 3804

    ipounder (10/28/2011)


    Good question, however the answer is a bit pedantic, so I'm going to be a bit pedantic in my comment. Whilst you can't disable full text search at the database level, you can achieve this in effect by disabling it at the table level, so if you do it on all tables, it is removed, is it not?:-)

    I would say not... because if I then add a full text index to a table I can still do a full text search.

    Whereas, in previous versions of SQL, if I'd disabled it at database level adding a full-text index would not result in the ability to full text search.

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • call.copse

    SSCoach

    Points: 17185

    Wot DugyC sed. Fortunately I overrode my immediate impulse to get this one right!

  • rfr.ferrari

    SSCertifiable

    Points: 6879

    good question!!! thanks!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • Iulian -207023

    SSCertifiable

    Points: 7509

    Nice one, thanks

    Iulian

  • Thomas Abraham

    SSChampion

    Points: 10761

    Not the first time using SSMS help has steered me in the wrong direction. I'm learning.

    Thanks for the question.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • SQLRNNR

    SSC Guru

    Points: 281243

    hmmm...interesting question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • OzYbOi d(-_-)b

    Hall of Fame

    Points: 3994

    good question - thanks!

Viewing 15 posts - 1 through 15 (of 22 total)

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