Solved

Full-text INFLECTIONAL not corresponding people/person

Posted on 2004-04-07
8
276 Views
Last Modified: 2006-11-17
I have a full-text indexed table and am able to pull a query using INFLECTIONAL that successfully pairs up louse/lice, mouse/mice. woman,women.  It's not finding person/people, however.  I imagine there's a dictionary lookup table within SQL server where it is simply missing this relationship.  I'm wondering if anyone knows where that table is or how I can find out.

Thanks,
Meg
0
Comment
Question by:mwidholm
  • 5
  • 3
8 Comments
 
LVL 3

Expert Comment

by:jayrod
ID: 10778692
A suggestion would be to use profiler to see where it is..

if there is not a query to a dictionary somewhere than I would look for an xml file under the mssql/data/ directory containing words and data for full text searches
0
 

Author Comment

by:mwidholm
ID: 10784449
Thanks jayrod.  I had never used profiler before, so I went in and it seems that where it's referencing the dictionary must be happening in the stored procedure, "sp_fulltext_data" and that's all the detail it's giving me.  Are these stored procedures viewable by sa?  I'm a dbo and I don't see it, but I can ask my boss to take a look.  He's very busy right now, so gaining access to stuff has been a pain.  

I had already looked under mssql/data, but the only xml files I found were 1kb.

Thanks for your help.
0
 
LVL 3

Expert Comment

by:jayrod
ID: 10784803
I couldn't find it either.. so not sure where to look from here.. I'll keep lookin tho
0
 

Author Comment

by:mwidholm
ID: 10785037
Well, I found "sp_fulltext_getdata" under the extended stored procedures in the master database.  However, I guess we can't see the code on those extended stored procedures and I'm back at square one.  I've been kind of poking at the system tables in the master now to see if any of them seem dictionary-esque.  I'm starting to feel like I'm reverse-engineering to fix a bug, which is probably incredibly impractical.  I'm so curious now though...
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 3

Accepted Solution

by:
jayrod earned 500 total points
ID: 10785083
I kind of guessed they may be extended stored procedures... so ya.. kind of hard to fix it or change it
0
 

Author Comment

by:mwidholm
ID: 10785672
I'm new here and don't entirely understand the point system.  While we didn't come to a solution, I appreciate your help tremendously and would like to give you the points- is that ok by the rules?
0
 
LVL 3

Expert Comment

by:jayrod
ID: 10785701
not sure.. you can ask for a refund of points after a certain amount of time if there aren't any answeres.

I'd leave it open for a while maybe let some others have a chance at giving some helpful information.

Come back in a few days and if no one has either posted some feedback or hints then you can close the question by assigning points or a refund.

either way it's all good :)
0
 
LVL 3

Expert Comment

by:jayrod
ID: 11053137
Hope you're still subscribed.. I finally found it. The thesaurus used for full text inflectional querying is found in:

c:\program files\microsoft sql server\ftdata\sqlserver\config

the thesaurus is in an xml file there. This is also where all of the noise words are stored.  As of service pack 2 the thesaurus option was implemented but disabled.

I found this data from sql Server 2k unleashed.

hope that helps ya..

although I just looked in that directory and I couldn't make heads or tails of the xml file. :P
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now