is it possible to return detailed information about fulltext searc
results, like linenumbers ?
I'm fairly new to using the fulltext search funtionality. I have bee
playing around with it for a few days now. Does anyone know if this i

I have the problem that if I search for certain phrases in SQL 2005 such
as "voice over", it returns no results.
I am using the following syntax:
declare @criteria varchar(100)

Hi out there,
could anyone explain?
System: WinServer 2003 German
SQL Server 2003

I have a fulltext indexed column which contains some like:
Section 0 Name
Section 1 Name
When I run a query like:

Making accent insensitive searches with Full Text Search
Installing an accent insensitive version of Microsoft Search
Service
It is really a shame that Microsoft did not provide a free solution for

Making accent insensitive searches with Full Text Search
Installing an accent insensitive version of Microsoft Search
Service
It is really a shame that Microsoft did not provide a free solution for

My SQL is instaled with CAse-Insensitive and Accent-Insensitive, but when I
search some thing with Full Text Search the result is diferent using accent
or not.
My server is a Windows 2000 server and MS SQL Server 2000.

I'm a bit lost in my Full_Text_Search_Adventure:
I've got a PDF-document in a SQL2005 table in which the following line
resides:
... homer is a computer geek ...

Hi.. SQL 2K issue. My client wishes to FTS for certain noise chars
only, e.g. % which of course isn't in the noise word files. The best
I've been able to come up with to resolve this is to escape the
characters when I enter the string into CONTAINSTABLE, however the

We're looking into the option of using dotLucene/seekafile server to do the
fulltext searching on a sql2000 database, but haven't really seen dotLucene
used directly with sql2000.
Does anyone know if it is possible to use Lucene/Seekafile server directly

Forgive me if this has already been asked, but I need to be able to
search either with accent sensitivity *or* insensitivity, depending on
user settings or locale.
Is there any way to set up my indexing (either in 2000 or 2005) so that

What is the query syntax when querying the full text indexer to obtain the
list of words indexed and their corresponding counts?

I know that we can know the population status with using
cscript gthrlog.vbs <file name>
but do you have any monitor script or job summary status about this..?
We need to proactive know about our population status..

    Should I build a full-text index on a field before or after I create a
non-clustered index on that field. Or does it matter?
Al.

I'm trying to figure out how to eliminate deadlocks in the system. It looks
like one process
involved in deadlock is process that populates FT index.  The second process
- is replication procedure