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