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

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

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