Hello,

I am using the following SQL query on SQL Server 2000:

select result from marksheet WHERE CONTAINS(result,'P')

It gives the following msg:

Server: Msg 7601, Level 16, State 3, Line 1
Cannot use a CONTAINS or FREETEXT predicate on column 'result' because it is not full-text indexed.

After I enabled Full Text Indexing & Full Population on column result
i got this:

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

Anybody plz. guide me about it if i am using CONTAINS keyword correctly or something else need to be done.

Regards
Monica

FROM BOL
Using Microsoft Internet Information Services and Indexing Service for File Content Searches
"Noise Words
Noise-word lists for many languages are provided and the set of supported languages is growing. The choice of a particular noise-word list is based on the language of the material which is file-format-dependent during the filtering process: Some files have the language setting by section (for example, by paragraph), whereas some specify the language setting as a property of the document. These noise-word lists should be sufficient for most normal operations, but can be modified for specific environments with a text editor. For more information, see the Indexing Service 2.0 documentation in the Windows NT 4.0 Option Pack."

You simply need to search using meaningful terms. In preparing the full text index, the engine ignores the trivial and unimportant noise words. So search on something like perspiration or inspiration or Thomas Edison or genius.


David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

Thanks David.