• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1222
  • Last Modified:

Suppressing FTSE Noise Word Warning Messagss

When querying a full-text indexed table in SQL 2005 using a CONTAINS predicate which contains noise words, SQL 2005 returns a warning message:

"Informational: The full-text search condition contained noise word(s)."

Executing the query from VBScript ASP using ADO, this warning message breaks the recordset.  The query IS returning results, because I have run sp_configure 'transform noise words', 1 , but ADO is broken by the warning messaage.

Is there some T-SQL that will get SQL to suppress this warning?

1 Solution
David ToddSenior DBACommented:

If you wrap the query with a stored procedure, is info message still being returned to VBScript ASP?

Just a thought.

Justin_GouldAuthor Commented:
It's actually already being called inside a stored procedure, and the warnings still burble up.  I really don't think there's a way to suppress it.
So far, what I've wound up doing is to filter the noise out on the client (ASP) side so that it doesn't make it to SQL.  It'd still be nice to know if there was a way to do this though.
The good news is that SQL Server has a setting for this:


The bad news is that it doesn't work on SQL Server 2008. So don't upgrade just yet!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now