Default Language missing in Full Text Indexing

  • I'm trying to build a FTI in SQL2005 EE, and receive the following error:

    "Default full-text index language is not a language supported by full-text search.

    Informational: No full-text supported languages found.

    When I go thru the GUI to build the FTI, the language field is blank, there are no choices in the drop down for me to choose.

    Here are some of the things I have looked at:

    /*------------------------

    sp_configure 'default full-text language'

    ------------------------*/

    name minimum maximum config_value run_value

    --------------------------- ----------- ----------- ------------ -----------

    default full-text language 0 2147483647 1033 1033

    /*------------------------

    select * from sys.fulltext_languages

    ------------------------*/

    lcid name

    ----------- ----------------------------------------

    Informational: No full-text supported languages found.

    Informational: No full-text supported languages found.

    (0 row(s) affected)

    /*------------------------

    select @@language

    ------------------------*/

    --------------------------

    us_english

    (1 row(s) affected)

    Any help on this is greatly appreciated!

    Thanks

  • Any update on the same?????????????????????/

  • when running "reconfigure" gives error

    -------

    Informational: No full-text supported languages found.

    Informational: No full-text supported languages found.

    Msg 5841, Level 16, State 1, Line 1

    The default full-text language is not supported by the full-text search component.

    ------------

    Kindly help on the same...........

Viewing 3 posts - 1 through 2 (of 2 total)

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