We are using:
Windows Server 2003 SP2
SQL Server 2000 SP2
Data is stored using periods such as 12.XT.1234.1

Did anyone find a solution to the problem below?
Regards,
Fredrik
---------------

I've got a full text index, with an empty noise word file. The table
has only 1 column + 1 timestamp for doing incremental updates (data
changes only once a day, in 1 time). Change Tracking is disabled
(OFF). SQL version is 2005 SP2 (9.0.3054)

I have got the following text in a column that is part of a full-text
index (SQL Server 2005):
    Lorem 7% ipsum
I understand that by default both the number 7 and the % character are

he current drive I'm using to store all of the full-text indexes for my
database is nearing capacity.  How do I change the disk location of a
full-text catalog?  All I want to do is point the full-text indexing service
used by sql server 2005 to a different drive with more space ...

Dears，
我们在使用MS SQL Server全文检索时，碰到如下问题，请各位大侠解释一下原因。
我们分别用“品位”和“品”查询某个text数据类型，发现结果很奇怪。
查询条件＝“品位”，在结果中看到该一笔记录如下：

Given a search string of "this is a sample of what I want to find" for
example, I want to know what sql fts actually searched for- i.e. the
string w/out the noise words.
Is there a built in function to trim out the noise words?

A very simple question about the difference in behaviour between 2000 and
2005 fti:
the following search in a parts catalog works in SQLServer 2000
select count(1)

This code does not appear to care that we have rows with both words vs
only one word...
select * from COLLABORATOR x inner join
containstable

As the title says, I'm having problems returning results when the
search string contains any of the words in the list in the title.
I'm damned if I can work out why this is happening, as my noise words
file is empty, and anyway, the search returns no results, even if

Does anyone know if there is a list of improvements to FT indexing in SQL
2008?
So far I've heard that it's integrated into the SQL Server engine and no
longer a seperate process? I'm assuming this has memory implications like

i need a way to match strings from one table on to another table. I am using
the "like"
but its not working correctly.
SELECT [PrimaryKey],[StockSymbole],[StockName] FROM [StockInfo]

I've seen lots of posts on this subject but no satisfactory answers. I asked
the question in 2004 before SQL 2005 arrived so I wondered if there is a
neat solution to this problem now. I want a way to get return one row from
the query below.

Hi all, I need a help for a problem related to full-text search.
Suppose I have Table A and Table B as following.
Table A
  ID      Data

Many of my customers have sites in both the US and UK or Australia/New
Zealand.
Thus, when one location searches for "colour", it would be really nice if
they also found things with "color".