I want to create a search engine which will display a short text
description in the surrounding of the searched words. The problem is I
can't find the exact words in my search phrase in the results because
of stemming. Is there any way I can which words in the results were

It seems like Track Changes Automatically is working, but the changes aren't
getting pushed into the index.
I had to turn it off and back on and force and update.
Am I missing something?

The following query:
SELECT PatientGUID
FROM PATIENT_SEARCH PS
WHERE PS.LicenseID = '465f20fc-8bd5-4802-a3f5-2a5f702be128'

I have been trying to get the following to work:
(select p.uid, p.title, (DATENAME(MONTH,p.newDate) + ' ' +
DATENAME(DAY,p.newDate) + ', ' + DATENAME(YEAR, p.newDate) ) as Date,
p.tableName from authorsPubs AP, publications p, authors a where

RESTORE FILELISTONLY
FROM DISK = 'C:\Full0100.BAK'
Here is the result
database d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\database

Is it possible to incorporate levenshtein edit distance and double-metaphone
matching into Sql Server 2005's Full-Text Search queries using FREETEXTTABLE
or CONTAINSTABLE?
I'm working on a web-site that allows user to search multiple tables, and i

I have a full text search index on a table with several fields
indexed.
I tried the following query :
SELECT     MyIndexedTable.MyIndexedTableID

I have implemented full text searching over files stored in a varbinary(max)
field and this works great :)
The only issue i am now having is that users creating office documents
created on a Windows Mobile device such as word docs are not being searched.  

Is there anywhere to download a fully-populated thesaurus list for SQL 2000
or SQL 2005 full-text search purpose?  The SQL online book mentioned that
"You will find a list of thesaurus files located in the
SQL_Server_install_path\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATA\

I work with SQL 2005 and I know how it uses RAM but I know just some basic
stuff about Full-text catalogs and since we plan to implement them in the
future I need to know a few things.
1. Can you set min and max memory for full text service like it can be set

Can't you have duplicate words with different meanings in different
expansion sets?  Is this a bug?
Please try this repro below.  It uses a thesaurus with 2 expansion sets.
Each set contains the word kind.  The sets are like this:

I have a contains string that says ' "Log In" ' which works fine and returns
results. I put in ' "Log" or "In" ' and I get results. I put in ' "Log" and
"In" ' and get "Informational: The full-text search condition contained
noise word(s)."

SQL Server Express 2005 with the Management Studio.
In SQL 2000, you can right click fulltext catalogs and select a "Rebuild"
option.
I can't find where to do this in the Management Studio.  I don't even see a

I am getting the rather odd error below; hope you can help.
RESTORE DATABASE is terminating abnormally. File 'C:\Program Files\Microsoft
SQL Server\MSSQL.1\MSSQL\Data\trial_44testingc' is claimed by
'sysft_KB_SearchAssetsCatalog'(65540) and 'sysft_KB_SearchCatalog'(65537).

After changing a noise file - does the FTS have to be restarted?
Also, any way to determine which noise.eng file is being used? There
are several locations...