- 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

 

-- Get languages information

EXEC sp_helplanguage

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

 

-- 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;

軒軒的爸媽 發表在 痞客邦 留言(0) 人氣()