August 15, 2011 at 10:11 pm
Hello,
I have following data in "title" column. The column "title" is included in my FullText search.
I have following data in title column:
up and down
up
upload
update
updated
I am searching "up" and using following query:
SELECT [Id], RANK FROM SearchLookup AS FT_SearchInfo WITH (NOLOCK) INNER JOIN CONTAINSTABLE(SearchLookup, (Title) , '"up*"') AS KEY_TBL ON FT_SearchInfo.ID = KEY_TBL.
I have removed all keyword from noise file that were present in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\Language\enu with NoiseFile at D:\Program file\MSSQL.1\MSSQL\FTDataoiseenu.txt location but no luck. when I am searching on title it is giving me upload, update and updated as results, not up and down.
i had result/reorganized that FullText Search also:
alter fulltext catalog MyTitleSearch rebuild
alter fulltext catalog MyTitleSearch reorganize
Furthermore, I have verified that all those noise words that were present in the noiseenu.txt file are still excluded by fulltext search query. those are as follows:
about
1
after
2
all
also
3
an
4
and
5
another
6
any
7
are
8
as
9
at
0
be
$
because
been
before
being
between
both
but
by
came
can
come
could
did
do
does
each
else
for
from
get
got
has
had
he
have
her
here
him
himself
his
how
if
in
into
is
it
its
just
like
make
many
me
might
more
most
much
must
my
never
no
now
of
on
only
or
other
our
out
over
re
said
same
see
should
since
so
some
still
such
take
than
that
the
their
them
then
there
these
they
this
those
through
to
too
under
up
use
very
want
was
way
we
well
were
what
when
where
which
while
who
will
with
would
you
your
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
if i search only wod "down' its showing me my desired search title "up and down" because the word "down" is not present in above list ... why this is happening ...
Please help me with SQL Server 2005 fulltext search.
Shamshad Ali.
August 16, 2011 at 5:20 am
I would restart Server and repopulate the full-text catalogs. Have you done this?
Also, are you sure that this is one noise file used?
August 16, 2011 at 7:02 pm
Yes, I have re-started the server also and I am sure about the noise text file as i have taken that file location from registry as mentioned in my post.
Shamshad Ali.
August 17, 2011 at 2:41 am
Try to remove everything from the noise file you changed, will you see any effect for other words?
August 17, 2011 at 8:46 pm
I have removed all words and the file is empty since beggining of my editing/testing to fix this issue without any luck.
Shamshad Ali.
August 18, 2011 at 2:43 am
When you've cleared the file, does search work for other noise words? If not the file you've changed is not the one used by sql server. What I'm trying to tell in my last few posts is that: most likely you changing the wrong file.
Do you run more than one sql server instance? Is it server or your local machine?
August 18, 2011 at 9:51 am
Eugene Elutin (8/18/2011)
When you've cleared the file, does search work for other noise words? If not the file you've changed is not the one used by sql server. What I'm trying to tell in my last few posts is that: most likely you changing the wrong file.Do you run more than one sql server instance? Is it server or your local machine?
I agree. The fulltext engine is still filtering out by the "up" noise word. Are you sure you removed "up" from the right noise file? Can you try removing it from Noiseneu ( neutral ) and other files that contain "up".
August 26, 2011 at 5:29 am
Hello.
Just for comfort; I have the same issue on one of my SQL Server 2005 boxes.
I even deleted the noiseXXX.txt files AND the full text catalog, created a new one and populated it with the desired columns with no effect other than the SQL Server no longer compains over noise words - just returns zero rows.
Rgds - Patrik
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply