I am trying to get FTS to work on an SQL Express (Advanced) database. I have
a table with a unique index(int), a column type field (nvarchar(15)) which I
set to "Image"  and a word document field (Image). I set up the catalog and
the full-text index and verified that both are ...

I get the following error:
Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed. A clause of the query contained
only ignored words.

Is there any way to 'read' a FT Index in SQLServer 2005.  We are having
problems getting our populations to index all records on one of our
SQLServer machines, and we would like to know which ones aren't getting
indexed.

I am reposting this under this subject area as it is more appropriate here.
----------------------------------------------
My understanding of the fulltext search using the thesaurus function is that
it will not work until the TSxxx.XML file is populated (in my case the

I have a table which contains the following data in one row:
ID      Category                Keywords
16558    Make-Up Assistants    makeup make up assistants
35976    Make-Up Artists        makeup make up artists

i created a job that performs indexing. the execution time takes only a
second. i noticed, however, using SQL Profiler that the process opened 32
connections!
trace details....

I have full-text running on one database only.  This index seems to have
issues about once every couple of weeks.  Normally, a search can be done (via
webpage) on a keyword - and it works fine.  But there are times that no
keyword (or other options) searches will work.  The only ...

Does Fulltext work on text fields?
I thought it didnt, but I just changed my varChar(8000) field to text and it
still seemed to work !
Thanks,

We recently migrated to the Windows 2003 and SQL2005. Besides many
things we have not pretty much tackled, there is one issue remaining
that I don't understand: Consider this query:-
SELECT TOP 250 *

Hi: I'm trying to get a handle on the best way to approach this issue.
I have a product database of candy with perhaps 5000 products, and I'm
indexing the product name and description fields (both varchars).
People will search for "easter candy" for example.

Howto do a sqlserver 2005 backup WITHOUT the FTS catalog using BACKUP
DATABASE  TO DISK T-SQL Command ?
Regards,
Frédérick

I have a windows app written in vb.net with an SQL Express backend, which is
used to track candidates and their resumes. Right now each candidate record
has a link to a word document resume. I would like to be able to search
resume's for key words in order to quickly locate all ...

Given the following table
Table : Computer
ID    Name             Notes
1     03-computer01    This webserver (ws) uses a SQL server

I have a database with ca. 150000 city names in the field city
(nvarchar).
When I now search like this:
...where CONTAINS(city,' "wash*" ')

Is it possible to explorer inside of full text indexes and see the words?
Thanks in advance,
Leila