Search code examples
sql-serverlocale

DBCC USEROPTIONS server/client

We are using MS SQL server 10.0, and running the DBCC options in two different user accounts, we get two different results. One has language us_english other as british. Where is the information stored on the server, is it possible to change it?

textsize    2147483647
language    us_english
dateformat  mdy
datefirst   7
lock_timeout    -1
quoted_identifier   SET
arithabort  SET
ansi_null_dflt_on   SET
ansi_warnings   SET
ansi_padding    SET
ansi_nulls  SET
concat_null_yields_null SET
isolation level read committed snapshot
Solution

  • In a word, yes. This setting is set on the login that the connection is using and changes all sorts of subtle behavior. Dates are especially affected (first day of the week etc).

    To view the default language settings for all logins run the following:

    SELECT name, sp.default_language_name FROM master.sys.server_principals AS sp

    That will show you the differences.

    If you want to change the default language of a login use the following syntax:

     ALTER LOGIN LoginName WITH DEFAULT_LANGUAGE = us_english