Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Alternatives to FTS in SQL7 cluster.
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 2nd May 18:49
charlie
External User
 
Posts: 1
Default Alternatives to FTS in SQL7 cluster.


We have a web app that hits our SQL 7 clustered database and the use of
Full-Text searches would solve a large problem we are having with queries to
a text column. I know FTS is not available in a SQL7 clustered environment
but I was wonder if anyone had come up with any alternatives. We have one
attribute that contains comments for the record and we currently use a LIKE
request in the query. Being as the table has some 300000 records in it the
search takes a long time.

I know this is a shot in the dark, but I have to extinguish all of my
possibilities.

Thanks,

Charlie.
  Reply With Quote


  sponsored links


2 2nd May 18:49
hilary cotter
External User
 
Posts: 1
Default Alternatives to FTS in SQL7 cluster.


site server search has a wizard that will allow you to
index SQL Server database or other ODBC data sources.

Its catalogs are accessible and queriable using
sp_oacreate objects within SQL Server, or you can access
them through asp.

and the use of

having with queries to

clustered environment

alternatives. We have one

currently use a LIKE

records in it the

extinguish all of my
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666