Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Note
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.
Example
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
See Also
Other Resources
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
14 April 2006 |
|