Re: Sql Server 2005 (beta2) API

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Craig (Craig_at_discussions.microsoft.com)
Date: 12/16/04 

Date: Thu, 16 Dec 2004 09:09:05 -0800

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: Sql Server 2005 (beta2) API
    ... 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 directly reading and writing to the XML Thesaurus files, ... > I managed to get the Thesaurus working for full text searching, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Sql Server 2005 (beta2) API
    ... So I guess Sql Server 2005 release will not have the functionality to read ... > Thesaurus files either via a GUI or even a command line tool would be most ... > related terms to update the Xml Thesaurus files and I have several ideas on ... >> Microsoft provided API is to ensure schema and location. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Linking error in mixed code
    ... namespace UnManagedFuncs ... First, it just seems more correct, since those API functions are stdcall. ... Since I haven't used C++/CLI I can't say for sure, but I had the impression that you could use the Windows API directly. ...
    (microsoft.public.vc.language)
  • Re: c# express support for adsi
    ... ADSI (Active Directory Service Interfaces) is a COM based ... API, which can be called from both native Win32 and managed code, ... System.DirectoryServices namespace from Visual C# 2005 Express Edition ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: [PATCH 1/3] genclk: add generic framework for managing clocks.
    ... * moved locks and list to genclk_ namespace ... as a doc for implemented API ...
    (Linux-Kernel)