Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

transform noise words Option

Updated: 14 April 2006

Use the transform noise words option to suppress an error message if noise words cause a Boolean operation on a full-text query to fail. This option is useful for full-text queries that use the CONTAINS predicate in which Boolean operations include noise words.

By default, transform noise words is set to 0 and noise words are not transformed. Thus, when noise words in the full-text query cause the operation to fail, Microsoft SQL Server raises a warning, and no rows are returned.

The warning is a run-time warning. Therefore, if the full-text clause in the query is not executed, the warning is not raised.

For a local query, only one warning is raised, even when there are multiple full-text query clauses. For a remote query, the linked server may not relay the error; therefore, the warning may not be raised.

When the transform noise words option is set to 1, SQL Server replaces noise words with the asterisk (*) in phrase queries.

The following example sets transform noise words to 1.

sp_configure 'show advanced options', 1
sp_configure 'transform noise words', 1

Release History

14 April 2006

Changed content:
  • Added information about the warning that is raised when the transform noise words option is not on.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft