Solved

set language in sql server 2005

Posted on 2013-05-17
2
290 Views
Last Modified: 2013-07-23
The default language of my sql server 2005 is us_english
I want to change it to french "definitively" I mean for all coming sessions
I know how to do in a stored procedure (set language french)  but I want to do it permanently so not having to issue the command in concerned stored procedure
And the same for the dateformat (set dateformat ymd)
0
Comment
Question by:LeTay
2 Comments
 
LVL 23

Expert Comment

by:Ioannis Paraskevopoulos
ID: 39176689
Hi,

You may want to check the solution hiven here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62891 

Read the last posts with the registry change. Be very very careful and do backups before you change everything.

Giannis
0
 
LVL 48

Accepted Solution

by:
PortletPaul earned 500 total points
ID: 39176706
the simple stuff
http://www.sqlusa.com/bestpractices/setdefaultlanguage/

registry tip (dd/mm/yyyy however) - easier to read, same author as above I think you will need to get the right values for your locale
http://coolkidsdoit.wordpress.com/2009/01/28/changing-the-default-languagelocale-sql-2005/

way harder stuff, but if you have many instances this might be useful
https://www.simple-talk.com/sql/sql-training/how-to-document-and-configure-sql-server-instance-settings/
not sure how much of this would apply to sql 2005 though
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now