|
|
You're in the
sql server full text search
group:SQL 2005 CTP - How can I get a full Thesaurus
sql server full text search:
How can I get and install a full Thesaurus into SQL Server 2005 CTP?
Thanks in advance! Wayne
there is no full thesaurus. Basically many people would be upset if they
started getting unexpected results coming back in their searches. So MS hands you a sample and has you customize it. You can find it at C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "wkbia" <wkbia@discussions.microsoft.com> wrote in message news:4B4E34F3-D180-4891-ADED-F879458E8BEC@microsoft.com... > How can I get and install a full Thesaurus into SQL Server 2005 CTP? > > Thanks in advance! > > Wayne >
That's a lot of work; can't expect a developer to be a grammer grad as well.
It would be nice if they supplied a full English thesarus that could be put online and modified as needed as I think more people are upset that they are not getting the results they expect from a thesarus search, this is why they're doing it. Inflectional searches seem to be fully functional and releasing a full-text thesarus search should be fully functional as well. I think I seen a post from you stating that you could get a thesarus from Word. Is this true and if so, can you tell me how I can obtain and install it. Thank you Hilary. I seen a lot of replies from you and I'm sure there are many who appreciate that you are doing this as I do. With best regards, Wayne [quoted text, click to view] "Hilary Cotter" wrote:
> there is no full thesaurus. Basically many people would be upset if they > started getting unexpected results coming back in their searches. So MS > hands you a sample and has you customize it. > > You can find it at C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\FTData > > -- > Hilary Cotter > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > "wkbia" <wkbia@discussions.microsoft.com> wrote in message > news:4B4E34F3-D180-4891-ADED-F879458E8BEC@microsoft.com... > > How can I get and install a full Thesaurus into SQL Server 2005 CTP? > > > > Thanks in advance! > > > > Wayne > > > >
-- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "wkbia" <wkbia@discussions.microsoft.com> wrote in message news:A866007B-676D-49C2-9365-77CB2E2ABA5B@microsoft.com... > That's a lot of work; can't expect a developer to be a grammer grad as well. > It would be nice if they supplied a full English thesarus that could be put > online and modified as needed as I think more people are upset that they are > not getting the results they expect from a thesarus search, this is why > they're doing it. Inflectional searches seem to be fully functional and > releasing a full-text thesarus search should be fully functional as well. > > I think I seen a post from you stating that you could get a thesarus from > Word. Is this true and if so, can you tell me how I can obtain and install it. > > Thank you Hilary. I seen a lot of replies from you and I'm sure there are > many who appreciate that you are doing this as I do. > > With best regards, > > Wayne > > > "Hilary Cotter" wrote: > > > there is no full thesaurus. Basically many people would be upset if they > > started getting unexpected results coming back in their searches. So MS > > hands you a sample and has you customize it. > > > > You can find it at C:\Program Files\Microsoft SQL > > Server\MSSQL.1\MSSQL\FTData > > > > -- > > Hilary Cotter > > Looking for a SQL Server replication book? > > http://www.nwsu.com/0974973602.html > > > > Looking for a FAQ on Indexing Services/SQL FTS > > http://www.indexserverfaq.com > > "wkbia" <wkbia@discussions.microsoft.com> wrote in message > > news:4B4E34F3-D180-4891-ADED-F879458E8BEC@microsoft.com... > > > How can I get and install a full Thesaurus into SQL Server 2005 CTP? > > > > > > Thanks in advance! > > > > > > Wayne > > > > > > > > >
I tried updating the tsENG.xml file but can't seem to get a thesaurus search to return a result other then the key word. car returns car, auto returns auto. Can you recommend anthing? The query: SELECT name FROM dbo.categories WHERE freetext(name, 'car') SELECT name FROM dbo.categories WHERE contains(name, 'FORMSOF(THESAURUS, "car")') Niether query works. Here's the xml file. <XML ID="Microsoft Search Thesaurus"> <thesaurus xmlns="x-schema:tsSchema.xml"> <diacritics_sensitive>0</diacritics_sensitive> <expansion> <sub>Internet Explorer</sub> <sub>IE</sub> <sub>IE5</sub> </expansion> <replacement> <pat>NT5</pat> <pat>W2K</pat> <sub>Windows 2000</sub> </replacement> <expansion> <sub>run</sub> <sub>jog</sub> </expansion> <expansion> <sub>car</sub> <sub>auto</sub> </expansion> </thesaurus> </XML> Thanks again. [quoted text, click to view] "Hilary Cotter" wrote:
> there is no full thesaurus. Basically many people would be upset if they > started getting unexpected results coming back in their searches. So MS > hands you a sample and has you customize it. > > You can find it at C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\FTData > > -- > Hilary Cotter > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > "wkbia" <wkbia@discussions.microsoft.com> wrote in message > news:4B4E34F3-D180-4891-ADED-F879458E8BEC@microsoft.com... > > How can I get and install a full Thesaurus into SQL Server 2005 CTP? > > > > Thanks in advance! > > > > Wayne > > > >
this is the list for UK English, I think you want tsENU.xml as you seem to
be in AZ. I tried your xml file and it works for me. -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "wkbia" <wkbia@discussions.microsoft.com> wrote in message news:D916682B-1293-4EAE-B245-93986340E098@microsoft.com... > > I tried updating the tsENG.xml file but can't seem to get a thesaurus search > to return a result other then the key word. car returns car, auto returns > auto. Can you recommend anthing? > > The query: > > SELECT name > FROM dbo.categories > WHERE freetext(name, 'car') > > SELECT name > FROM dbo.categories > WHERE contains(name, 'FORMSOF(THESAURUS, "car")') > > Niether query works. > > Here's the xml file. > > <XML ID="Microsoft Search Thesaurus"> > > <thesaurus xmlns="x-schema:tsSchema.xml"> > <diacritics_sensitive>0</diacritics_sensitive> > > <expansion> > <sub>Internet Explorer</sub> > <sub>IE</sub> > <sub>IE5</sub> > </expansion> > <replacement> > <pat>NT5</pat> > <pat>W2K</pat> > <sub>Windows 2000</sub> > </replacement> > <expansion> > <sub>run</sub> > <sub>jog</sub> > </expansion> > <expansion> > <sub>car</sub> > <sub>auto</sub> > </expansion> > </thesaurus> > > </XML> > > Thanks again. > > "Hilary Cotter" wrote: > > > there is no full thesaurus. Basically many people would be upset if they > > started getting unexpected results coming back in their searches. So MS > > hands you a sample and has you customize it. > > > > You can find it at C:\Program Files\Microsoft SQL > > Server\MSSQL.1\MSSQL\FTData > > > > -- > > Hilary Cotter > > Looking for a SQL Server replication book? > > http://www.nwsu.com/0974973602.html > > > > Looking for a FAQ on Indexing Services/SQL FTS > > http://www.indexserverfaq.com > > "wkbia" <wkbia@discussions.microsoft.com> wrote in message > > news:4B4E34F3-D180-4891-ADED-F879458E8BEC@microsoft.com... > > > How can I get and install a full Thesaurus into SQL Server 2005 CTP? > > > > > > Thanks in advance! > > > > > > Wayne > > > > > > > > >
I actually found this out after my post. I also just found out that you need
to use the language argument in the sp_fulltext_column procedure as it doesn't default. Dropping the argument, the procedure seemed to execute correctly as there was no warning, but it hadn't. Got it working now... Thank you. Wish I had a somewhat complete thesarus though, or at least one that I could modify. Do you or anyone else no where I could get one and preferably free since I have no capitol at this time. Thanks again and in advance. Wayne [quoted text, click to view] "Hilary Cotter" wrote:
> this is the list for UK English, I think you want tsENU.xml as you seem to > be in AZ. > > I tried your xml file and it works for me. > > -- > Hilary Cotter > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > "wkbia" <wkbia@discussions.microsoft.com> wrote in message > news:D916682B-1293-4EAE-B245-93986340E098@microsoft.com... > > > > I tried updating the tsENG.xml file but can't seem to get a thesaurus > search > > to return a result other then the key word. car returns car, auto returns > > auto. Can you recommend anthing? > > > > The query: > > > > SELECT name > > FROM dbo.categories > > WHERE freetext(name, 'car') > > > > SELECT name > > FROM dbo.categories > > WHERE contains(name, 'FORMSOF(THESAURUS, "car")') > > > > Niether query works. > > > > Here's the xml file. > > > > <XML ID="Microsoft Search Thesaurus"> > > > > <thesaurus xmlns="x-schema:tsSchema.xml"> > > <diacritics_sensitive>0</diacritics_sensitive> > > > > <expansion> > > <sub>Internet Explorer</sub> > > <sub>IE</sub> > > <sub>IE5</sub> > > </expansion> > > <replacement> > > <pat>NT5</pat> > > <pat>W2K</pat> > > <sub>Windows 2000</sub> > > </replacement> > > <expansion> > > <sub>run</sub> > > <sub>jog</sub> > > </expansion> > > <expansion> > > <sub>car</sub> > > <sub>auto</sub> > > </expansion> > > </thesaurus> > > > > </XML> > > > > Thanks again. > > > > "Hilary Cotter" wrote: > > > > > there is no full thesaurus. Basically many people would be upset if they > > > started getting unexpected results coming back in their searches. So MS > > > hands you a sample and has you customize it. > > > > > > You can find it at C:\Program Files\Microsoft SQL > > > Server\MSSQL.1\MSSQL\FTData > > > > > > -- > > > Hilary Cotter > > > Looking for a SQL Server replication book? > > > http://www.nwsu.com/0974973602.html > > > > > > Looking for a FAQ on Indexing Services/SQL FTS > > > http://www.indexserverfaq.com > > > "wkbia" <wkbia@discussions.microsoft.com> wrote in message > > > news:4B4E34F3-D180-4891-ADED-F879458E8BEC@microsoft.com... > > > > How can I get and install a full Thesaurus into SQL Server 2005 CTP? > > > > > > > > Thanks in advance! > > > > > > > > Wayne > > > > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |