Re: containstable noise words

Did you remove the M from your noise word lists and rebuild the catalog? You
will need to stop MSSearch/MSFTEsql when making this change.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"geek-y-guy" <noone@xxxxxxxxxxx> wrote in message
news:%231CKLmD0GHA.4816@xxxxxxxxxxxxxxxxxxxxxxx
If I use a containstable query against a word like "M&M" I get a response

Informational: The full-text search condition contained noise word(s).
(0 row(s) affected)

Even though there are many rows with "M&M" in them.

How can I get around this?




.

Relevant Pages

  • Re: Invalid Descriptor Index
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.replication)
  • Re: Backup failure due to full-text indexing
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Shift the backup log after backup database (it was starting at the same ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: sp_addarticle without re-creating entire new snapshot
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... "Hilary Cotter" wrote: ... Use Paul ...
    (microsoft.public.sqlserver.replication)
  • Re: Web Synchronization over HTTPS fails
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... "Hilary Cotter" skrev: ...
    (microsoft.public.sqlserver.replication)
  • Re: Fulltext and cluster - odd problem
    ... Hilary Cotter ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... [Location of errorlog files] ...
    (microsoft.public.sqlserver.fulltext)
Loading