Export (0) Print
Expand All
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.

ms187914.note(en-US,SQL.90).gifNote:
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
RECONFIGURE
GO
sp_configure 'transform noise words', 1
RECONFIGURE
GO

Release History

14 April 2006

Changed content:
  • Added information about the warning that is raised when the transform noise words option is not on.

Community Additions

ADD
Show:
© 2014 Microsoft