Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / December 2004

Tip: Looking for answers? Try searching our database.

Sql Server 2005 (beta2) API

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Craig - 15 Dec 2004 15:35 GMT
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
John Kane - 16 Dec 2004 16:26 GMT
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

> Maybe someone knows if this is possible...
>
[quoted text clipped - 8 lines]
>
> Craig
Craig - 16 Dec 2004 17:09 GMT
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

> Craig,
> I need to research this a bit with my newly installed Dec 2004 CTP version
[quoted text clipped - 25 lines]
> >
> > Craig
John Kane - 17 Dec 2004 07:00 GMT
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

> Hi John
>
[quoted text clipped - 54 lines]
> > >
> > > Craig
Craig - 17 Dec 2004 13:59 GMT
Hi John

So I guess Sql Server 2005 release will not have the functionality to read
and write the thesaurus files via an API.  I can write this class as well,
it'll be serialized and require prehaps a .config to enable alternate install
locations of the files.  When I'm done, I'll post them back to the news group.

After updating the thesaurus file, does the MSFTESQL service require a
re-start for the updates to take effect?

Craig

> You're welcome, Craig,
> Yes, (MSFTESQL$SQL90 - for my named instance: SQL90), hopefully (and in this
[quoted text clipped - 87 lines]
> > > >
> > > > Craig
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.