Full Text searches

• dnf999

  SSC Eights!

  Points: 870

  More actions

  February 27, 2007 at 3:07 am

  #177032

  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!

• bledu

  SSChampion

  Points: 12335

  More actions

  February 27, 2007 at 4:51 am

  #692002

  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.
  

• dnf999

  SSC Eights!

  Points: 870

  More actions

  February 27, 2007 at 4:58 am

  #692003

  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.....

   

• bledu

  SSChampion

  Points: 12335

  More actions

  February 27, 2007 at 5:12 am

  #692005

  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.
  

• John Kane

  SSCrazy

  Points: 2810

  More actions

  February 28, 2007 at 9:02 am

  #692329

  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