Solved

Suppressing FTSE Noise Word Warning Messagss

Posted on 2008-10-08
3
1,089 Views
Last Modified: 2008-11-03
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?

0
Comment
Question by:Justin_Gould
3 Comments
 
LVL 35

Expert Comment

by:David Todd
ID: 22683816
Hi,

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

Just a thought.

Cheers
  David
0
 

Author Comment

by:Justin_Gould
ID: 22702834
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.
0
 
LVL 1

Accepted Solution

by:
neilx earned 500 total points
ID: 22836315
The good news is that SQL Server has a setting for this:

http://msdn.microsoft.com/en-us/library/ms187914.aspx

The bad news is that it doesn't work on SQL Server 2008. So don't upgrade just yet!
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to writing scripts for a Client/Server computing environment it is essential to consider some way of enabling the authentication functionality within a script. This sort of consideration mainly comes into the picture when we are dealin…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now