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

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

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

Related articles:

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

SQL Server Default Languages and Misinterpretation