[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Suppressing FTSE Noise Word Warning Messagss

Posted on 2008-10-08
3
Medium Priority
?
1,195 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 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This is pretty cool.  The purpose of this VB Script is to help you document where JAR (Java ARchive) files and specifically java class files are located so that you can address issues seen with a client or that you can speak intelligently with a dev…
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

873 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