Charlie 2012-05-02 17:49:32
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
Hilary cotter 2012-05-02 17:49:36
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
alternatives. We have one
currently use a LIKE
records in it the
extinguish all of my