datetime tune date into pad dynamic cursor money percent sp job isnumeric while over update
FREE TRIAL  SQL 2012 PROGRAMMING  SEARCH
SQL Server Scripts SQL 2005 SQL 2008 Articles
SQL JOBS NEWS FORMAT DEV JOBS
How to find out default language & default database settings?

Execute the following Microsoft SQL Server T-SQL scripts in Management Studio Query Editor to demonstrate the getting and setting of default language and default database:

 

-- Find out default language

SELECT @@language

------------

 

-- Find out default database

SELECT loginname as LoginName,

       dbname as DefaultDatabase,

       DATABASEPROPERTYEX(dbname, 'Status') as DatabaseStatus

FROM sys.syslogins

ORDER BY LoginName

------------

-- Get all languages information

EXEC sp_helplanguage

------------

 

-- Setting default language for login

use master

 

EXEC sp_defaultlanguage 'kimberlyhay', 'us_english'

GO

 

 

-- SQL Server 2005 and onward

ALTER LOGIN kimberlyhay WITH DEFAULT_LANGUAGE = British;

GO

 

 

-- Languages in SQL Server 2008 with dateformat

SELECT LanguageID = langid,

       name,

       alias,

       dateformat

FROM     sys.syslanguages

ORDER BY langid

GO

-- Results

LanguageID name alias dateformat
0 us_english English mdy
1 Deutsch German dmy
2 Français French dmy
3 日本語 Japanese ymd
4 Dansk Danish dmy
5 Español Spanish dmy
6 Italiano Italian dmy
7 Nederlands Dutch dmy
8 Norsk Norwegian dmy
9 Português Portuguese dmy
10 Suomi Finnish dmy
11 Svenska Swedish ymd
12 čeština Czech dmy
13 magyar Hungarian ymd
14 polski Polish dmy
15 română Romanian dmy
16 hrvatski Croatian ymd
17 slovenčina Slovak dmy
18 slovenski Slovenian dmy
19 ελληνικά Greek dmy
20 български Bulgarian dmy
21 русский Russian dmy
22 Türkçe Turkish dmy
23 British British English dmy
24 eesti Estonian dmy
25 latviešu Latvian ymd
26 lietuvių Lithuanian ymd
27 Português (Brasil) Brazilian dmy
28 繁體中文 Traditional Chinese ymd
29 한국어 Korean ymd
30 简体中文 Simplified Chinese ymd
31 Arabic Arabic dmy
32 ไทย Thai dmy

------------

 

-- Setting default database for login

EXEC sp_defaultdb 'kimberlyhay', 'AdventureWorks'

 

-- SQL Server 2005 and SQL Server 2008

ALTER LOGIN kimberlyhay WITH DEFAULT_DATABASE = AdventureWorks2008;

------------

Related articles:

How to: Set the Default Language (SQL Server Management Studio)

SQL Server Default Languages and Misinterpretation

 

Exam Prep 70-461
Exam 70-461