SQL Server - How to change the language in SQL server 2005, when i execute "select @@Language" i get

Asked By Rajendra Reddy on 26-Jun-12 03:08 AM
Earn up to 30 extra points for answering this tough question.
Chintan Vaghela replied to Rajendra Reddy on 27-Jun-12 01:12 AM

Hi Frndz,

 

Functionality:  Change Default Language in SQL server

 

 

To achieve this task,

 

Configure as following steps

 

Step : 1

 

First you need to reconfiguration you database language

 

There is two way to reconfiguration

 

First Way

 

Go to Object Explorer >> Right Click Select Properties >> Go To Advance

 

Change Default Language  DropDown value from Right Side  to set as per your need

 

 

Second Way

 

EXEC sp_configure 'default language', 23

RECONFIGURE

 

 

Step : 2

 

 

Alter your login name with Default language

 

Use following way

 

ALTER LOGIN sa WITH DEFAULT_LANGUAGE = British;

Instead of sa you need to type your sql server login credentials

 

 

 

Table for LanguageID and Name

 

LanguageID

name

alias

0

us_english

English

23

British

British English

 

Get more Language name using following query

 

SELECT LanguageID = langid,

 

     name,

 

     alias

 

FROM   sys.syslanguages

 

ORDER BY langid

 

Note :: once you done with above thing close your SQL server Managment Studio.... Reopen again

 

 

Verify your Language using folloiwng styntax

 

select @@LANGID, @@LANGUAGE

 

 

 

Hope this helpful!

Thanks