Solved

set language in sql server 2005

Posted on 2013-05-17
2
291 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

Suggested Solutions

Title # Comments Views Activity
How to enforce inte 8 50
SSIS how to COMPARE a data column from different servers? 6 95
Help Required 2 29
Find results from sql within a time span 11 29
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…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

815 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

12 Experts available now in Live!

Get 1:1 Help Now