Visite Webhosting Latino, el site sobre alojamiento web.
Alternatives to FTS in SQL7 cluster. - Mombu the Microsoft Forum
Mombu the Microsoft Forum sponsored links

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

sponsored links

1 2nd May 18:49
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


  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

Thread Tools
Display Modes

Copyright 2006 - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -