Searching the text of a collection of documents or free text fields in a database to find those containing a word or combination of words.

learn more… | top users | synonyms

2
votes
2answers
374 views

Should SQL full text search match the value test2 when searching for test?

if i have table data that is indexed using full text search in Microsoft SQL server 2005 that includes raw table data such as "test2" should a query using FTS find a match if the search string is ...
2
votes
1answer
243 views

Why doesn't FTS match any records?

I created an indexed view with a few fields that i created a full text search based on these fields. here is my view: alter VIEW vFullTextSearch WITH SCHEMABINDING AS SELECT M.Id as MessageId, ...
1
vote
2answers
236 views

create a FTS in sql2005 on multile fields in multiple tables?

How can I create a Full Text Search catalog on 3 fields where one is in a second table?
5
votes
1answer
2k views

How to install SQL Server Express 2005 with Full text search

I am in need to Install SQL server 2005 Express edition with Full Text Search capability. I don't know what to download and the order of installing the Database management system. Could someone ...
3
votes
1answer
385 views

How to get the Oracle Text Index's underlying Virtual XML Document?

The Oracle Text Reference 10g states that when we index our table using multi-column datastore, the system concatenates the text columns, tagging the column text, and indexes the text as a virtual XML ...