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

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

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