I have seen multiple posts that state a where clause can help filter a
full-text search to ensure no full-text records are searched.  What I
understand when showing "set statistics io on" -- the worktable is what the
FTE uses to search for the CONTAINS.  Whether I have a filter ...

Hi, when triying to reindex a full text catalog of 25 million rows, the
process hangs when reaching the row 7 to 12 million, after 12 hours of
runing.
its a 4cpu and 4gb server it has 30gb of free disk space.

I have installed SQL Server 2005 Express Edition with Advanced Services. The
problem is that I see no full text search service on my computer.
Please help
/RAM/

I would like to help me to restore the FTS database in another machine. The
problem is that in the main server the drive letter is different than in the
one where I want to restore, in the production(main) server drive in M, in
the test server I can put it in D, for instance. Can ...

Has anyone played with the <diacritics> or <diacritics_sensitive> tag in the
thesaurus for FTS?  If so, have you actually gotten it to affect your
results?  It doesn't matter what I change it to, in testing it appears to be
over-ruled by the FT Catalog accent sensitivity setting.

Quick question.  The diacritics_sensitive tag of the thesaurus XML files,
should it be:
#1) <diacritics_sensitive>0</diacritics_sensitive>
Or:

Hi there :)
I have a problem and don't know how to resolve it. I had sharepoint portal
server 2003, then it was upgraded to 2007, but after that two meeting
workspace been lost. Lost from sharepoint site, but not from the DB. Wrote

I'm using fulltext indexes and I can't understand what happens in the file
system.
This is my test:
1. I create the catalog:

its query results hits in a highlighted format. I was able to
programmatically get this working for simple searches, where I simply
do a find and replace based on the search criteria. But this will not

I am using asp.net (C#) to create full text searching using SQL Server
2005 in our application. Everything is working fine, but I am trying
to highlight the resultset keywords from the full text results. Can
sql server provide you with a way to highlight the keywords from the

from SQL Server 2005 I access a index server an another computer (cp-
tkl)
select * from openquery(IDXNAME, 'select filename from "cp-
tkl".idxc..scope()')

It is strange that full text search for the same db and tables is working in
one server, but not in another one.
Error log for this:
Event Type:    Warning

I brought this up once ago, but I read something which might open a
new possibility. What I am trying to do is this:
select p.Name, p.Score, ft.Rank
from Products p

I have installed SQLServer 2005 for take advantage of full text seach
features.
When I start full population, there are some rows that cause error and not
are indexed.

I receive Message 7653 when I try this:
CREATE FULLTEXT INDEX
ON Products
(Name LANGUAGE 0x0)