Changing Default Language of SQL Server 2005

Question

Post reply

Changing Default Language of SQL Server 2005

ankur_libra

Hall of Fame

Points: 3999
More actions
April 7, 2010 at 10:04 am

#139338

Hi All,
Is it possible to change the default language installed on the SQL server 2005?
Our Scenario:-
On one of our esteemed client , we have a production SQL Server 2005 on which Default language installed is Spanish. Now all the Maintenance plans created already are listed in Spanish language only.
As this server is coming in our scope now, so we want to get an understanding of the already created Maintenance Plans/jobs.
So:-
1. Can we permanently change the default language of the sql server to English from spain? So that we can create the new objects/Maintenance plan in English only.
2. What would be its effect on the current users?
3. On searching on Net , i found some options like SET LANGUAGE, sp_defaultlanguage , Sp_Configure etc.
Please help so that we can state the same in advance to client.
Thanks in Advance
With regards,
Ankur

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ankur_libra Hall of Fame Points: 3999 More actions · Answer 1

Hi All,

Let me know if some other information is required..

With regards,

Ankur

Source-NH SSCarpal Tunnel Points: 4165 More actions · Answer 2

ankur_libra (4/7/2010)
Hi All,
Is it possible to change the default language installed on the SQL server 2005?
Our Scenario:-
On one of our esteemed client , we have a production SQL Server 2005 on which Default language installed is Spanish. Now all the Maintenance plans created already are listed in Spanish language only.
As this server is coming in our scope now, so we want to get an understanding of the already created Maintenance Plans/jobs.
So:-
1. Can we permanently change the default language of the sql server to English from spain? So that we can create the new objects/Maintenance plan in English only.
2. What would be its effect on the current users?
3. On searching on Net , i found some options like SET LANGUAGE, sp_defaultlanguage , Sp_Configure etc.
Please help so that we can state the same in advance to client.
Thanks in Advance
With regards,
Ankur

No. The default language for the Instance cannot be changed without Deinstalling and Reinstalling SQL Server. However, the language for the databases can be changed. This will NOT affect ANY existing data. In order to change the data, you would need to recreate the plans in the new language. Unfortunately, you are stuck in regards to your existing maintenance plans.

Rich

ankur_libra Hall of Fame Points: 3999 More actions · Answer 3

Thanks Rich for your valuable response.:-)

Please also clarify that what setting should be changed so that from now onwards, new maintenance plans, jobs and objects are created in English Language only.

With regards,

Ankur

ankur_libra Hall of Fame Points: 3999 More actions · Answer 4

Hi All,

I came to know that if we can reinstall the client tools in English language, it can help to get the SSMS Items like Menu, Maintenance Plans, Jobs in English language only.

Note:Right now, SQL server/agent error logs are listing in English language only whereas Maintenance plans/wizards are showing in Spanish language.

I am just concerned that while creating new maintenance plans, jobs or creating new objects, all details/wizards shows English only.

Please clarify would it be possible.

Thanks in advance

With regards,

Ankur