軒軒的爸媽

- 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

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

-- Setting default database for login

EXEC sp_defaultdb 'kimberlyhay', 'AdventureWorks'

-- SQL Server 2005 and SQL Server 2008

ALTER LOGIN kimberlyhay WITH DEFAULT_DATABASE = AdventureWorks2008;