Microsoft® SQL Server® 2012 Bible

508

Part V: Enterprise Data Management

In Management Studio, you can set the default full-text language confi guration

option by specifying the local identifi er (lcid) for the language you want, as listed in the

sys.fulltext_languages table in the Default Full-Text Language box on the Server

Properties Advanced tab (refer to Figure 19-10).

The following example sets the default full-text language option to US English

using T-SQL code:

EXEC sp_configure 'show advanced options', 1;

RECONFIGURE;

EXEC sp_configure 'default full-text language', 1033;

RECONFIGURE;

In this case, the value of 1033 refers to US English. You need to change this value only

when you need to support something other than the default system language.

Many of the language settings in SQL Server rely on a locale identifier (LCID). You can fi nd a list of com-

mon LCID values at http://msdn.microsoft.com/en-us/goglobal/bb964664.aspx.

Default Language

The default language for all newly created logins can be set in Management Studio as well

as in code using the default language confi guration option. The default language

is used for messages from the server and formatting dates. It can be overridden by the

CREATE LOGIN or ALTER LOGIN statements.

In Management Studio, set the default language confi guration option by selecting the

language from the Default Language drop-down list on the Server Properties Advanced tab

(refer to Figure 19-10).

From code, you can set the default language confi guration option by specifying the

unique language id of the language you want, as listed in the sys.syslanguages table.

For example, to set the default language to British English, fi rst query the sys.syslanguages

table to get the language id for British English. Then use the language id in the code:

EXEC sp_configure 'default language', 23;

RECONFIGURE;

The language for a session can be changed during the session through the SET LANGUAGE statement.

Two-Digit-Year Cutoff

The two-digit-year cutoff converts a two-digit year to a four-digit year based on the values

supplied. The default time span for SQL Server is 1950–2049, which represents a cutoff year

c19.indd 508c19.indd 508 7/30/2012 5:43:06 PM7/30/2012 5:43:06 PM

http://www.it-ebooks.info