Saturday, September 29, 2012

Changing SQL Server Default Language

If you needed to change the default language of a SQL Server login you can do so by using sp_defaultlanguage command.

First determine the current default language by using the @@language variable as follows.

  1. SELECT @@language

Then choose the language you want to change to from the available languages. You can find the available languages by the following command.

  1. EXEC sys.sp_helplanguage

After selecting the language wanted to change, run the following command to change the default language, I am changing it to British using the following command.

  1. DECLARE @Login NVARCHAR(30)
  2. SET @Login = SYSTEM_USER
  3. EXEC sp_defaultlanguage @Login, 'British'

Run the @@language to see whether the default language is changed as you wanted. Do not forget to use a new query window to see the changes.

8 comments:

Anonymous said...

I'm more than happy to discover this great site. I need to to thank you for ones time just for this fantastic read!! I definitely liked every little bit of it and I have you book marked to check out new information on your web site.
Here is my website ; free web page hosting

Anonymous said...

Hi i am kavin, its my first time to commenting anyplace, when i read this
post i thought i could also create comment due to this brilliant article.
My weblog : Search Marketing seo

Anonymous said...

Very nice article. I definitely love this site. Keep it up!
Check out my weblog ; works at home

Anonymous said...

I am really impressed with your writing skills as well as with the layout on your weblog.
Is this a paid theme or did you modify it yourself?
Anyway keep up the nice quality writing, it is rare to see a nice blog
like this one today.
Feel free to surf my webpage ; business home

Anonymous said...

Heya i'm for the first time here. I found this board and I find It truly useful & it helped me out a lot. I hope to give something back and aid others like you helped me.

Also visit my homepage; young entrepreneurs business ideas

Anonymous said...

I am regular reader, how are you everybody? This article posted at this website is actually nice.


Feel free to visit my web-site ... Credit Union Student Loans Consolidation

Anonymous said...

Hi there very nice blog!! Guy .. Beautiful .. Wonderful ..
I will bookmark your site and take the feeds also? I'm satisfied to seek out numerous helpful information here in the submit, we want work out more techniques on this regard, thank you for sharing. . . . . .

Here is my web-site ... how can i get a home loan with bad credit

Anonymous said...

Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically
tweet my newest twitter updates. I've been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.

Also visit my website; search engine placement