MSSearch without SQL Server

We are using MSSearch via SQL Server to perform free-text searches.
However, we would rather not store the entire raw text in the SQL
Server. So is there a way to use the MSSearch service outside the
context of SQL Server? In other words, to populate MSSearch directly
with free-text, let it build its index and query either MSSearch
directly or indirectly via SQL Server but without actually storing the
free-text in SQL Server.
Hope someone can help me out here.
Thanks in advance
Thomas
Not really. What you could do is create a linked server to Index
Server/Indexing Services and then query it this way.
Here is how to add a linked server to the system catalog Indexing Services
uses.
sp_AddLinkedserver any_name, 'Indexing Service', 'MSIDXS', 'your catalog
name'
and then query like this
create procedure test_index @.strsearch varchar(20) as
declare @.strSQL varchar(244)
select @.strSQL='select FileName,path, vpath from scope() where contains ('
select @.strSQL=@.strSQL +char(39)+ char(39)+ @.strsearch
+char(39)+char(39)+')'
select @.strSQL='select * from openquery(any_name,'+ char(39)+
@.strSQL+char(39) +')' exec (@.strSQL)
The performance offered is not the best, so you might want your client to
access the Indexing Services query objects directly, ixsso offers better
performance than msidxs and ado.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Thomas Stryger Olsen" <thomas.stryger.olsen@.gmail.com> wrote in message
news:88bfcba4.0501070717.58614f1b@.posting.google.c om...
> We are using MSSearch via SQL Server to perform free-text searches.
> However, we would rather not store the entire raw text in the SQL
> Server. So is there a way to use the MSSearch service outside the
> context of SQL Server? In other words, to populate MSSearch directly
> with free-text, let it build its index and query either MSSearch
> directly or indirectly via SQL Server but without actually storing the
> free-text in SQL Server.
> Hope someone can help me out here.
> Thanks in advance
> Thomas
|||Thomas,
Where does most of your "raw text" reside today? In SQL Server 2000 table(s)
or in files on the server's hard disk?
If most of the raw table is on the server's local disk drive, you may want
to consider one of the many desktop search tools, such as those listed at
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!249.entry
Specifically, dtSearch can index and search data in SQL Server as well as
files on the disk.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Thomas Stryger Olsen" <thomas.stryger.olsen@.gmail.com> wrote in message
news:88bfcba4.0501070717.58614f1b@.posting.google.c om...
> We are using MSSearch via SQL Server to perform free-text searches.
> However, we would rather not store the entire raw text in the SQL
> Server. So is there a way to use the MSSearch service outside the
> context of SQL Server? In other words, to populate MSSearch directly
> with free-text, let it build its index and query either MSSearch
> directly or indirectly via SQL Server but without actually storing the
> free-text in SQL Server.
> Hope someone can help me out here.
> Thanks in advance
> Thomas

MSSearch for words between two other words

I've been asked to find a way of doing some complex searches against a
SQL Server 2000 database using MSSearch.
The company I'm contracting to wants to know if there is a way to
perform a search such as:
"sql" within x number of words of "database" (x could be any number)
I'm not that versed with any more than the basic searches within
MSSearch, so this one's a stumper for me. Any help on this would be
appreciated.
They are using ColdFusion to develop the interface between the web and
the database.
Thanks,
CalgaryDataGrl
Hey Calgary Data Girl - I used to live in Calgary - born in Edmonton, and
lived in the nwt for some time!
To answer your question - no, they do have the near operator but it doesn't
define how near. Other search products (like Indexing Services) does allow
you to define the separation in terms of number of words, lines, paragraphs,
pages and chapters.
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
<calgarydatagrl@.gmail.com> wrote in message
news:1169569044.310656.316520@.s48g2000cws.googlegr oups.com...
> I've been asked to find a way of doing some complex searches against a
> SQL Server 2000 database using MSSearch.
> The company I'm contracting to wants to know if there is a way to
> perform a search such as:
> "sql" within x number of words of "database" (x could be any number)
> I'm not that versed with any more than the basic searches within
> MSSearch, so this one's a stumper for me. Any help on this would be
> appreciated.
> They are using ColdFusion to develop the interface between the web and
> the database.
> Thanks,
> CalgaryDataGrl
>