Full Text searches

  • Hi I have been asked to configure SQL Server for full text searches, but do not know what this means.

    Can anybody inform me what this is, and how to do it?

    I can't get a clear explanation or how to do it online...

    THanks!

  • Ref: BOL

    Full-Text Catalogs and Indexes

    A Microsoft® SQL Server™ 2000 full-text index provides efficient support for sophisticated word searches in character string data. The full-text index stores information about significant words and their location within a given column. This information is used to quickly complete full-text queries that search for rows with particular words or combinations of words

    To enable a database for full-text indexing

    Enterprise Manager:

    How to enable a database for full-text indexing (Enterprise Manager)

    To enable a database for full-text indexing

    Expand a server group, and then expand a server.

    Expand Databases, and then click a database to enable.

    On the Tools menu, click Full-Text Indexing.

    Complete the Full-Text Indexing Wizard.

    -----------

    Just go under Full Text Searching on Book on Line.

    --------

    Full text searching is useful when you want to select info like as below

    -- Execute a full-text query against the new table.

    SELECT article_title

    FROM FulltextTest

    WHERE CONTAINS(article_title, ' "Steven Buchanan" AND "ice skating" ')


    Everything you can imagine is real.

  • Excellent, is this the same for SQL Server 2005?

    I know you have to download a free kit from the Microsoft site, but I can't download at the mo.....

     

  • BOL 2005

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/a0ce315d-f96d-4e5d-b4eb-ff76811cab75.htm

    you will find all the info you want.


    Everything you can imagine is real.

  • You can also go to my blog:

    SQL Full Text Search Blog

    http://jtkane.spaces.live.com/

    for more info and links on SQL FTS, both SQL Server 2000 and SQL Server 2005. I will soon have it moved to http://www.SQLFTS.com  (under construction) and more detailed and up-to-date articles and links there.

    Thanks,

    John


    John T. Kane

Viewing 5 posts - 1 through 4 (of 4 total)

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