Here's a SQL Server 2008 fulltext indexing problem that 3 days of head-
scratching hasn't alleviated. There are four known symptoms:
Symptom 1. All fulltext queries timeout after 10s with the message:
"Msg 30053, Level 16, State 102, Line 1

Is there any way to count the number of times a string occurs in all
rows of a full text indexed column?

The enclosed query if run with just project manager in the search
phrase returns a specific record, just searching for surrey returns
the same record so we have concluded that the record contains both
search items. When we put them together in the search as coded below

I'm little bit confused and need help. I'm querying using the following query
Select * from User where Contains(Address,'"ca*" OR "ca" OR "*ca" OR "*ca*")
This query returns me
1. california

I'm little bit confused and need help. I'm querying using the following query
Select * from User where Contains(UserName,'"rob*" OR "rob" OR "*rob")
This query returns me
1. Robert

The search feature is no longer working correctly for one on our sites.
When i try running the following:
EXEC sp_fulltext_database 'enable'
I'm receiving the following error:

We are using SQL FTS feature big time to allow search in our repository to
data. Most of the data is text data stored in Varbinary type of column in
html format.
While doing performance testing we find out that following statement is

We have a fulltext catalog, configure with CHANGE_TRACKING OFF and we have a
Timestamp column. After adding some new data, we execute an “ALTER FULLTEXT
INDEX ON [MyCatalog] START INCREMENTAL POPULATION”.
It’s work well but each START INCREMENTAL POPULATION, fire a master merge;

fulltext html file on disk, don't use binary field to stored file content.
Are there way to SQL Server 2008 can indexed physical htmlfile?
Thanks

According to the SQL SERVER 2005 Books Online, "To create a full-text index
on a table, the table must have a single, unique not null column. "
However, the table I would like to have Full-Text Search enabled has only an
composite primary key(two columns)  as index.

I currently have the Adobe PDF iFilter v6 working with SQL Server 2005, but
have noticed a number of PDFs are not being returned in searches that should
find them. I believe I've narrowed this down to the v6 Adobe iFilter not
supporting PDF Packages, of which all of these PDFs ...

I have a SQLSERVER2000 table (the design of which is outside of my control,
but I can get indexes added) with a telephone number column which I join to a
table (which is in my control) to identify the call type.
e.g.