Was this page helpful?
Your feedback about this content is important. Let us know what you think.
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

Use the transform noise words option to suppress an error message if noise words, or stopwords, cause a Boolean operation on a full-text query to return zero rows. 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 (or stopwords) are not transformed. When a full-text query contains noise words, the query returns zero rows, and SQL Server raises a warning.


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 might not relay the error; therefore, the warning might not be raised.

Noise words (or stopwords) are transformed. They are ignored, and the rest of the query is evaluated.

The following example sets transform noise words to 1.

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

Updated content

Removed incorrect content and replaced it with correct information about the behavior of the transform noise words values.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft