Changing the default language/locale SQL 2005

We had this problem in a dev environment the other day.  The developers decided to tell us after we’d installed and configured SQL and the SharePoint farm they needed to change the language settings of SQL because they were trying to input dates in dd/mm/yyyy (United Kingdom format), and by default SQL is setup with mm/dd/yyyy (US format).

It’s quite a simple fix, stop all SQL services, open up regedit and in the following areas change Language from 1033 to 2057 (decimal)

  • HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup\CurrentVersion
  • HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup
  • HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup
  • HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\CurrentVersion

This will change the DEFAULT INSTANCE ONLY.  If you have other instances, change MSSQL.1 to MSSQL.2/etc for them.  To verify, run the following;

  • SET Language British
  • select @@Language, @@Langid

This should return the value British 23.  In the Properties of the SQL Instance in Management Studio, you will see;

English (United Kingdom)

English (United Kingdom)

Advertisements

One thought on “Changing the default language/locale SQL 2005

Leave a Reply

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

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 )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s