I have enabled full text search on the products table. It works as
expected most of the times but does not return any thing for keyword
like IL-8. Please try searching for IL and IL-8 on this
page(http://4.19.91.45/bs/searchresult.asp). The noise.eng file does

I've had a FT-indexed database working for a month or so - have had no
problems with it. This is SQL Server 2000, SP3a. There are 50,000 rows in
the table in question, and new rows are not being added, nor are the
existing rows changing - they've been static since they were ...

We have two tables that have full text indexes, currently both are using the
same catalog.
One table is much larger and the column being indexed contains more data.
Would there be any advantage of seperating the indexes into tow seperate

Anyone have any experience building large full text indexes on SQL
Server 2005.  I am trying to build a 100 Million row index using
Full-Text 2005  JUNE CTP.  My average row size is about 500 chars in a
varchar field.

So I've edited all copies of noise.enu (the correct file foe US English) by
removing 'c' from the line with the alphabet.
I did restart on the Indexing service and forced a full population on the
two tables we have fulltext indexes on.

I did this on my new production server.
I rebooted the server and forced a full rebuild of the indexes.
The server still tells me my query only contains noise words.
It worked correctly on the old production server and on our dev server.

I went and edited all three instances of the noise.eng files on the server.
I forced the server todo a full population of the indexes.
The problem is, of course, it finds every instance of the letter "C", not
only when it occurs by itself, but even when it occurs inside a word.

Dear sirs,
How to set full-text indexing on table which has multi-columns as primary
key?
Thanks

Is there a way to specifically add ".NET" or "C++" so that they WILL be
indexed inside of word or rtf docs?
Or is there a replacement IFilter that will do it?
Kyle!

I hope someone can help me with this one.
We have an SqlServer2000 database SP3, running on Win2003 server.
On of the tables in one of the databases we use the fulltext search, and we
have set up schedules jobs, one doing a incremental population on the

Thanks for any help!
SQL 2000 Standard Edition with SP3.  The title and document column are both
Full text indexed.  The problem I'm trying to solve is how to get the below
stored procedure to search BOTH columns for the criteria entered.

When comparing results of SQL's Full-Text Catalog
to the IIS 6.0 Index Server to ANY other commercially
available vendor's offerings, like a Lexus-Nexus search
or Imceda Software or DeiselWorks, which produces

I have response problem with Full Text Index which is 600MB in Size and
growing incrementally. Previously we had 128MB Ram and 350MB of index size
then size of index increases to 600MB due to insertion of data after this
performance degraded so we increased the RAM to 256MB now ...

The table I'm using has full-text columns and also a date column thats
indexed. If I do a query on a date range and the full-text column does SQL
Server return the full-text rows first, then subset by date, or subset by
date and pass that set of rows to MSSEARCH?

When running the following query against MS SQL Server 7.0:
SELECT
documentitems.manufacturerpartnumber,documentitems.customnumber01,documenthe
aders.customnumber01,documentit