Managing Full-Text Search

SQL Server supports all languages that are supported by Microsoft Windows operating systems. To help the Database Engine perform searches efficiently, you should set the default language for full-text searches, manage stopwords and stoplists, and configure the thesaurus file.

Setting the Default Full-Text Language

When you select a default full-text language, the Database Engine uses that language to index data stored in char, nchar, varchar, nvarchar, text, and ntext columns. This language is also the default language used at query time if the language_term clause is not specified as part of a full-text search. If you don’t set a default full-text language, this option is set the same as the default language for the SQL ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.