?
Solved

Disable word stemming, declensions, conjugations in sql server 2005 freetext search

Posted on 2007-03-20
2
Medium Priority
?
414 Views
Last Modified: 2008-09-09
Lots of confusion with new SQL Server 2005 freetext search.
This is my most recent problem:

<< SELECT Txt FROM Table1 WHERE  CONTAINS , ' "ANAESTHETIKUM*" ')  >>
finds also Txt Columns with "ANAESTHETIKA" inside.

This is probably a word stemming problem in german language.
But  isnt this kind of search ment to have a syntax like
"Select * from TableName where CONTAINS(*,'FORMSOF(INFLECTIONAL,ANAESTHETIKA)')"

Is this done because I have a default full-text language of German?
How can I disable all that stuff?

Thanks for any light...
duke63
0
Comment
Question by:duke63
2 Comments
 
LVL 43

Accepted Solution

by:
Eugene Z earned 1500 total points
ID: 18757562
0
 

Author Comment

by:duke63
ID: 18791817
Thanks EugeneZ,
(sorry for the late response)
I've  allready read these pages but could not find a reason for this behavior?
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question