February 27, 2007 at 3:07 am
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!
February 27, 2007 at 4:51 am
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" ')
February 27, 2007 at 4:58 am
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.....
February 27, 2007 at 5:12 am
February 28, 2007 at 9:02 am
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