Why have phrase matches stopped working in my 2008 instance?
According to [this]: > Use of WEIGHT, FORMSOF, wildcards, > NEAR and other syntax is not allowed. > freetext_string is wordbroken, > stemmed, and passed through the > thesaurus. **If freetext_string is > enclosed in double quotation marks, a > phrase match is instead performed**; > stemming and thesaurus are not > performed. Indeed, this has worked just fine for me up until now (mostly on 2005). But on my 2008 instance at home, it's suddenly started ignoring the double quotes in any query I do: SELECT TOP 3 Title FROM Articles WHERE FREETEXT([Title], '"global warming"') Results: China takes Congress-centered stance in prevention of global warming Global Nanotechnology R&D Hub Taking Shape in Tsukuba Warming-related drought leads to decline in plant growth, reversing earlier trend Why is the `FREETEXT` predicate stripping or ignoring the double quotes in my query? I found [this] post that seems to suggest this behavior has changed in 2008. Does that mean the MSDN documentation is incorrect? And how can I most easily restore/simulate the previous behavior? :