I am using SQLServer 2000. When i searched for 'C#' or 'C++'
Ex:
CONTAINS(Table.*, '"C#"')
getting results that does not have 'C#' or 'C++'.

I'm working on an aplication that could benefit from having the hit
location inside of a column. For example
A Column has
"United Stated Education System : Educational Stuff"

Quick question, I have a set of full text catalog files that we would
like to use to re-create a set of catalogs on a new build database, as
part of a build script. I have copied a set of files to a devstore on
out SAN with the intention of moving these to each local file system

Is it possible to list all of the current Full Text Indexes on a given
database by using a command or statement through the query analyzer?
My problem is that i setup a full text index for a database 1 year ago
and have since forgotten its name and from what i can tell my

L.S.
While running a full population on a full-text index the following
message keeps coming almost every second in the Event Log:
Event Type:    Error

Hi,
Sometimes, I got the following error while trying to perform a database
backup.
This backup is done on a regular basis using a maintenance plan.

I am executing the followings SELECT and the results are not as
expected.
======================================
Search 1

What was the verdict on the two ways to perform the full-text query,
contains vs. containstable?
It seemed the original poster found that containstable worked faster and
wanted to know if was essentially the same query.  The question also was

I was reading BOL, and I came across this statement:
"Many document types can be stored in a single varbinary(max), or xml
column. Microsoft SQL Server 2005 supports certain document types and
provides a filter for these types."

Env: sql 2k sp3 Ent. ed running on win2k3 active/passive cluster
When SQL SP3 was applied on the cluster it failed to upgrade ms search on
the passive node
causing ms search on the two nodes to go out of sync.

Hiya,
I have several database on a SQL2005 server.  They have fuill text indexing
enabled.  They all have one catalog referred to one table.  Currently they
have not been populated so are therefore empty.

I have recently used the 'top_n_by_rank' clause in a full text
query in order to reduce the query execution time.
Here is the senario - we have a table called 'article' that has
three fields.

We have SQL 2000 on one server.  We are trying to configure full text
searchin within Project Web Access on another server.   We have noticed
that the "Microsoft Search" service is not even listed on the Project
Server.  How is that added/installed?

My clients need to be able to search on identification numbers that are
formatted like '5-1' or '10-23'.  In the first instance, I can't do it at
all, because the wordbreaker breaks 5 and 1 apart, then ignores both as
noise words.  In the second case, I get a bunch of stuff back ...

Seemingly a simple thing but something is wrong:
SELECT * FROM PERSON WHERE company_id = 7410 AND CONTAINS(first_name,
'Daniel') takes 2.5 minutes.
SELECT person.* FROM CONTAINSTABLE(PERSON, first_name, 'Daniel') AS a