Using SQL2000 as a document search engine 
Author Message
 Using SQL2000 as a document search engine
Hi,

Someone once told me that you could use SQL2000 to read ind index a bunch of
word documents, then use it as a free text search engine, is this true ?

If so what do I need ?

Jane S

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.***.com/ - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----



Wed, 27 Apr 2005 14:49:55 GMT
 Using SQL2000 as a document search engine

If you are going to store those word docs on a database, you can set up the
full text catalogs on your sql server database.


Quote:
> Hi,

> Someone once told me that you could use SQL2000 to read ind index a bunch
of
> word documents, then use it as a free text search engine, is this true ?

> If so what do I need ?

> Jane S

> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----



Wed, 27 Apr 2005 17:16:09 GMT
 Using SQL2000 as a document search engine
Thanks Ricky, I dont quite understand though. I dont really want to store
the documents in the database (wouldnt know how to anyway) - and how do I
set up full text catalogs ?

JaneS


Quote:
> If you are going to store those word docs on a database, you can set up
the
> full text catalogs on your sql server database.



> > Hi,

> > Someone once told me that you could use SQL2000 to read ind index a
bunch
> of
> > word documents, then use it as a free text search engine, is this true ?

> > If so what do I need ?

> > Jane S

> > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----


Wed, 27 Apr 2005 19:05:37 GMT
 Using SQL2000 as a document search engine
If you don't want to store the documents in the database, then SQL Server
isn't going to help you.  Full Text Catalogs (which you can lookup in SQL
Server's Books Online) are the mechanism SQL Server provides for indexing
documents stored in SQL Server.  And it sure isn't free...you have to buy
SQL Server.

--
Hal Berenson
True Mountain Consulting


Quote:
> Thanks Ricky, I dont quite understand though. I dont really want to store
> the documents in the database (wouldnt know how to anyway) - and how do I
> set up full text catalogs ?

> JaneS



> > If you are going to store those word docs on a database, you can set up
> the
> > full text catalogs on your sql server database.



> > > Hi,

> > > Someone once told me that you could use SQL2000 to read ind index a
> bunch
> > of
> > > word documents, then use it as a free text search engine, is this true
?

> > > If so what do I need ?

> > > Jane S

> > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > > -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----



Thu, 28 Apr 2005 00:35:05 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Using SQL2000, returning an XML document (string) instead of a recordset, from a stored procedure

2. using CONVERT to search binary documents

3. Search documents using Ingres 2 ??

4. Searching Word Documents with Full Text Searching

5. NEWBIE: search engine for the XML files, using SQLServer

6. search engine using containstable

7. Search Engine using DAO with SQL

8. Building Search Engine using Oracle 8i interMedia Text

9. Creating A Search engine using Filemaker

10. Using Search engines as data source

11. Searching multiple fields with the Excalibur search engine??

12. printing Word documents from ADP 2002 and Sql2000


 
Powered by phpBB® Forum Software