I'm trying to do a FREETEXTTABLE search on two columns.
I can get it to work correctly with searching only one column.
I basically need it to do an OR on the two columns and haven't been
able to find anything on that. It seems like I'm limited to finding

I learned recently that Microsoft has a Most Valuable Professional (MVP)
program to recognize, honor and reward people who regularly provide
technical support for Microsoft products through discussion groups.  For
information about the MVP program, see

This question concerns searching in a windows sharepoint services site.
 I have posted the question there and have been advised to post it here
instead.
As WSS uses 100% standard SQL Server 2K full-text search, is it possible

Is there a way to get additional match information from SQL Server
2000 CONTAINSTABLE?  For example:
If my text data is:
The black bird and the blue bird...

here is a simple question :
How to simply create a good search engine with the  FULLTEXT functionnality
of  SQL SERVER?
In fact, I have done something....

I'm using FREETEXTTABLE and would like to use wildcards, but I'm not getting
expected results.
SET @SearchCriteria = '"*rose*"'
The above appears to ignore the wildcard before the text.

The following FREETEXTTABLE query works, but I'm getting all rows returned.
The highest ranked are
at the top like expected, but it's also returning all rows in the Stock
table that have no match whatsoever. In my FREETEXT query (bottom), all the

I have a Sharepoint installation and a SQL Server.
Full text indexing is enabled - in Sharepoint and on the SQL Server.
Using enterprise manager, I see the Full-text index, the tables/columns that
will be indexed.

i'm trying do this in sql:
the mysql query:
"SELECT id FROM browser WHERE '$http_user_agent' REGEXP browser_regexp"
where $http_user_agent is a string i.e."mozilla/4.0 (compatible; msie 6.0; windows nt 5.0; .net clr 1.1.4322" and the browser_regexp is column in table "browser" with ...

Will the full text catalog break if I delete all the records from a table. I dropped the table and the Full text catalog broke.
My assumption is that it is attached to the table and when the  table is dropped the catalog is also lost. Is this correct.
I need to change all the ...

I have several instances of SQL Server 2000 Personal Edition running on 2000
Pro and XP Pro.
Are there any issues with installing Full-Text Search on these machines?
Thanks

We are having significant performance problems with full-text indexing on one
column of a large database.
System configuration:
 Windows 2000 Advanced Server with all service packs as of 6/10/04.

1) The following query works fine and gives me the results I want. Is there
a better more efficient way of writing this?
DECLARE @SearchCriteria varchar(100)
SET @SearchCriteria = ' "midler" '