Solved

Suppressing FTSE Noise Word Warning Messagss

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Table create permissions on SQL Server 2005 9 41
Caste datetime 2 57
Query 14 55
Adding automation to a search and and replace a character in a text file. 5 46
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…
Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

778 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