<div>
Hi,<br />
<br />
If you wrap the query with a stored procedure, is info message still being returned to VBScript ASP?<br />
<br />
Just a thought.<br />
<br />
Cheers<br />
&nbsp; David
</div>


Hi,

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

Just a thought.

Cheers
  David

<div>
It's actually already being called inside a stored procedure, and the warnings still burble up. &nbsp;I really don't think there's a way to suppress it.<br />
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. &nbsp;It'd still be nice to know if there was a way to do this though.<br />

</div>


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.


<div>
<div class="content wysiwyg-content">
When querying a full-text indexed table in SQL 2005 using a CONTAINS predicate which contains noise words, SQL 2005 returns a warning message:<br />
<br />
&quot;Informational: The full-text search condition contained noise word(s).&quot;<br />
<br />
Executing the query from VBScript ASP using ADO, this warning message breaks the recordset. &nbsp;The query IS returning results, because I have run sp_configure 'transform noise words', 1 , but ADO is broken by the warning messaage.<br />
<br />
Is there some T-SQL that will get SQL to suppress this warning?<br />
<br />

</div>
</div>


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?



Suppressing FTSE Noise Word Warning Messagss

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.