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?