June 23, 2010 at 7:40 am
Our SQL Server 2005 64 bit servers are all running with the langage English (United States). When I tried to change it using the scripts below, it returned successful but is still running as English (United States).
EXEC sp_configure 'default language', 23
RECONFIGURE
SELECT @@language, @@langid
How can I change it and how can I stop it installing as English (United States)?
Madame Artois
June 23, 2010 at 7:56 am
Hi,
I think its possible only through registry change and to be considered very carefully.
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup\CurrentVersion]
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup]
In these 3 keys there are language settings. It's DWORD so when you edit the key, it needs to be changed to Decimal and put your language code in. (http://msdn.microsoft.com/en-us/library/ms190303.aspx)
Once done, either restart the SQL services or restart the server (if possible).
[font="Verdana"]Renuka__[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply