Solved

set language in sql server 2005

Posted on 2013-05-17
2
298 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql Audit table 3 96
Loops and updating in SQL Query 9 71
Parse this column 6 38
Why is this SQL bringing back extra rows? (parsing XML data) 4 66
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

732 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