Re: Sql Server 2005 (beta2) API

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: John Kane (jt-kane_at_comcast.net)
Date: 12/17/04 

Date: Thu, 16 Dec 2004 23:00:24 -0800

You're welcome, Craig,
Yes, (MSFTESQL$SQL90 - for my named instance: SQL90), hopefully (and in this
area especially), the Yukon based documentation will improve over the SQL
Server 2000 BOL entries on FTS! Post your example when your can.

Yes, an easier way to make changes, additions and deletions to the Xml
Thesaurus files either via a GUI or even a command line tool would be most
helpful! I would even go so far as to say for true production-level use of
these Xml Thesaurus files to be effective, a method of extracting keywords
from the SQL table's FT-enabled text and then relating these terms to their
synonyms, antonyms, hypernyms and "Related Terms" is required to provide
true thesuraus functionality. Then one could use the extracted keywords and
related terms to update the Xml Thesaurus files and I have several ideas on
how to achieve this as well.

I suspect that this may be outside the scope of tasks to be completed in
order to ship SQL Server 2005 on time and with high quality & reliability,
but I hope that something like both of these tools could developed and
released as a sample app &/or in the Resource Kit...

Stay in touch,
John

"Craig" <Craig@discussions.microsoft.com> wrote in message
news:66166385-5526-44A6-B5D8-0ACB3477987B@microsoft.com...
> Hi John
>
> Thanks for the reply.
>
> MSFTSQL
> The closest thing I found to starting and stopping the service was in the
> Microsoft.SqlServer.Management.Smo.Wmi namespace, the most likely class
being
> the ServiceCollection which contains classes of type Service. The
> documentation doesn't say, but I'm assuming the Service properties are
> read-only, makes sense that they are, the Service class methods include
> give-aways such as Start, Stop, Pause etc. I'm working up an example to
test
> this.
>
> Xml Thesaurus Files
> The application I'm designing requires FTS across multiple languages (6 in
> total). I would like the administrators of this system to be able to
> configure the thesaurus words in a 'cleaner' way than having them dig into
> the Xml files directly on the Sql Server box. So that advantage of a
> Microsoft provided API is to ensure schema and location. In turn I
provide a
> UI that would interact with the API. The classes that may provide this
sort
> of functionality are again in the Microsoft.SqlServer.Management.Smo
> namespace i.e. XmlRead but the documentaion doesn't tell me what Xml these
> classes are capable of reading. The class FullTextService doesn't offer
any
> clues on how the thesaurus files are read into Sql Server.
>
> Appreciate any tip-bits you have.
>
> Craig
>
>
> "John Kane" wrote:
>
> > Craig,
> > I need to research this a bit with my newly installed Dec 2004 CTP
version
> > of SQL Server 2005 (Yukon). Can I assume you've searched the SQL Server
2005
> > BOL and have found no SQL Server 2005 API namespace that accomplishes
this?
> > As for stopping and re-starting the MSFTE service, have you tried
> > sp_fulltext_service ?
> >
> > As for directly reading and writing to the XML Thesaurus files, why
would
> > you want to do this? I can see the advantages of such an API, but I'd be
> > most interested in your reasons as to why you believe such an API would
> > provide additional value to SQL FTS enabled applications.
> >
> > Thanks,
> > John
> >
> >
> >
> >
> > "Craig" <Craig@discussions.microsoft.com> wrote in message
> > news:CA04C8CC-482D-4657-B8C3-59C987E33696@microsoft.com...
> > > Maybe someone knows if this is possible...
> > >
> > > I managed to get the Thesaurus working for full text searching, which
> > > required me to restart the msftesql service.
> > >
> > > So my question, is there a programable way to restart the service
within
> > the
> > > Sql Server API namespaces? If so, any ideas as to which class? Also,
> > does
> > > the API offer a class to read and write to the Xml thesaurus files?
> > >
> > > Many thanks
> > >
> > > Craig
> >
> >
> >

Relevant Pages

  • Re: Thesaurus Files
    ... The XML Thesaurus Files in SQL 2005 (and un-supported by MS in SQL ... > API) file was encoded as unicode. ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)