SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Operations
Administration (Database Engine)
Managing Servers
Setting Server Configuration Options
access check cache Options
ad hoc distributed queries Option
affinity I/O mask Option
affinity64 I/O mask Option
affinity mask Option
affinity64 mask Option
Agent XPs Option
allow updates Option
awe enabled Option
backup compression default Option
blocked process threshold Option
c2 audit mode Option
clr enabled Option
common criteria compliance enabled Option
cost threshold for parallelism Option
cross db ownership chaining Option
cursor threshold Option
Database Mail XPs Option
default full-text language Option
default language Option
default trace enabled Option
disallow results from triggers Option
EKM provider enabled Option
enable_force_flush Option
filestream access level Option
fill factor Option
ft crawl bandwidth Option
ft notify bandwidth Option
index create memory Option
in-doubt xact resolution Option
lightweight pooling Option
locks Option
max degree of parallelism Option
max full-text crawl range Option
max text repl size Option
max worker threads Option
media retention Option
min memory per query Option
nested triggers Option
network packet size Option
Ole Automation Procedures Option
open objects Option
optimize for ad hoc workloads Option
ph timeout Option
precompute rank Option
priority boost Option
query governor cost limit Option
query wait Option
recovery interval Option
remote access Option
remote admin connections Option
remote login timeout Option
remote proc trans Option
remote query timeout Option
Replication XPs Option
scan for startup procs Option
server trigger recursion Option
set working set size Option
Server Memory Options
show advanced options Option
SMO and DMO XPs Option
SQL Mail XPs Option
transform noise words Option
two digit year cutoff Option
user connections Option
user instances enabled Option
user instance timeout Option
user options Option
xp_cmdshell Option
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

transform noise words Option

SQL Server 2008 R2

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.

NoteNote

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.

Copy 
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'transform noise words', 1
RECONFIGURE
GO

Updated content

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

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.