I had a fulltext index catalog created on a table with 1 column being
indexed.  I needed to add another column from the same table, so I
added the new column to the catalog and restarted a full population
again.

We recently created a table with an FTI in a database, then created a view to
this table in another database.  We found we were not able to access the FTI
using CONTAINS through the view.
We got round it by changing our SP to use the FQN instead of the view, but

Hello, there is the chance to know  "how near" one word is to another
in the following query
SELECT Description
FROM Production.ProductDescription

I want to Index Tiff images by using Sql Server 2000.
But i couldn't find any IFilter for indexing Tiff Images.
Can anyone help?

I have a table with all the support tickets of my clients, I need to know,
whene was the first ticket of each user, I know distinct can do that, but I
need the full row.
I tried this:

I am experiencing a strange behavior in a full text search using the
CONTAINS predicate.
SELECT SomeField
FROM SomeTable

Does anyone know what the differences are between the full version and the
express slq server 2005 are?
Or send a link to a site that might lead me in the proper direction.
Thank you in advance.

1) I've read timestamp isn't really convertible to datetime, but can a
timestampfield tell me when a specific row was indexed, just to be sure
adaptions where reflected in the index ... or does it only store whe a row
was updated in order to let the system know it has to be indexed ...

Hi,
I am trying to customize SPS's search, it goes well with a little problem,
My web part finds the documents that contains a specific word,
But if my Search phrase is a noise word (for example "one", "and", "is",

    I noticed that when I did an export on a database (lets call it DB_a)
to another one (lets call it DB_b) it did not copy over the full text
index (FTI) that was on DB_a.
    Is there anyway I can get the FTI from DB_a to be copied over to DB_b

Okay,
I believe I am missing something crucial to fulltext searching.  We are
looking at ways to change a search from using "like" to "contains" in
hopes of improving search performance on a table.  We have a fulltext

re SQL Server 2000
I've read some info on John Kane's blog about different behaviour of the
work-breaking DLLs for Win2K and Win2003 Server (and WinXP - ? not sure),
and he gives the example of "AT&T".

I have the following setup. Full population works fine on a table with
53 rows, unique pk etc. but when i turn change tracking and background
index update on the FTI is not updated. Any thought are much
appreciated! -THanks, Dave

I have two tables setup for full text indexing.
If full text catalogs where created and are being populated once a week
fully and incrementally every day.
Would full text still work if Full - Text Search Engine is stopped?

I have a table ADSFULL containing ADVERTISMENTS with a FTI index on 2 fields
FADS_TITLE and FADS_TEXT (see script at the end).
--
The following query returns 94 rows.