Solved

Suppressing FTSE Noise Word Warning Messagss

Posted on 2008-10-08
3
1,071 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
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…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

743 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

11 Experts available now in Live!

Get 1:1 Help Now