• Home
  • About

Arjuna's space

Welcome to my space in the internet
Stay updated via RSS

  • Use of Information Provided

    The freely provided content in this site is for your information only, you are always welcome to mention your ideas and errors on my site if at all. But at no way you should make me (Arjuna Chiththananda) liable for any loss or damage whatsoever you incur due to the use of the information provided in this site.
  • Recent Posts

    • Windows Explorer Crashing in Windows 11
    • Your Information Leaked?
    • Error Installing Windows 11 on VMWare Player
    • Toyota RAV4 2011 AWD and 2WD Maintenance Schedule
    • Toyota RAV4 2011 AWD and 2WD Maintenance Information
  • Categories

    • Android (3)
    • Aviation (12)
    • Cars (7)
      • Maintenance (2)
    • Computers and Internet (40)
      • Windows Server (8)
      • Word (2)
    • Development (110)
      • .Net (44)
      • .Net Compact Framework (8)
      • AJAX (3)
      • CRM (1)
      • CSS (6)
      • Excel (2)
      • HTML (2)
      • IIS (2)
      • JavaScript (4)
      • PowerShell (3)
      • SharePoint (25)
      • SQL Server (30)
    • Drama (1)
    • Entertainment (15)
    • Facts (3)
    • Fruit (3)
    • Gadgets (6)
    • Games (1)
    • Hardware (4)
    • Health and Wellness (1)
    • Hotels (1)
    • Impressive Ideas (3)
    • Kids (1)
    • Mobile (21)
    • Music (1)
    • Nature (9)
      • Caves (2)
      • Waterfalls (4)
    • New Software (3)
    • Office (5)
    • Organizations (1)
    • Photoshop (1)
    • Security (1)
    • Shopping (1)
    • Songs (1)
    • Toyota (4)
      • RAV4 (4)
    • Trains (1)
    • Travel (34)
      • Adelaide (7)
      • Australia (24)
      • Queensland (1)
      • Singapore (1)
      • South Australia (19)
      • Sri Lanka (3)
      • Victoria (3)
    • Uncategorized (10)
    • Web (16)
    • Windows (39)
  • Translate

Changing SQL Server Default Language

Posted: September 29, 2012 in SQL Server
Tags: Database, Default Language, Login, Query, SQL
1

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.

Advertisement

Share this:

  • Twitter
  • Facebook

Like this:

Like Loading...

Related

Comments
  1. Importing Data into SQL « Arjuna's space says:
    October 2, 2012 at 12:40 AM

    […] Changing SQL Server Default Language […]

    Reply

Leave a Reply Cancel reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

Change Quick Access Default Application Icons on Samsung Galaxy S2
Importing Data into SQL

Blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Arjuna's space
    • Already have a WordPress.com account? Log in now.
    • Arjuna's space
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Copy shortlink
    • Report this content
    • View post in Reader
    • Manage subscriptions
    • Collapse this bar
%d bloggers like this: