Language Settings

[Pete]

When I look at the properties of my SQL installation, the general tab shows the language setting as English (US). How do I make a perm change to British? I have the settings for British in my syslanguages table.

Thanks in advance.

[Mohammed.]

sp_configure ....
default language option ...

Mohammed.


------------
Pete at 10/1/01 7:08:47 AM


When I look at the properties of my SQL installation, the general tab shows the language setting as English (US). How do I make a perm change to British? I have the settings for British in my syslanguages table.

Thanks in advance.

[Pete]

Thanks for that, but I've already tried it.
sp_configure now shows the language value as "23"
@@language and @@langid return correctly

BUT

the general tab on the installation properties is incorrect
as is xp_msver

The operating system however shows as correctly as British as well.

Any thoughts? Thanks!


------------
Mohammed. at 10/1/01 1:20:50 PM

sp_configure ....
default language option ...

Mohammed.


------------
Pete at 10/1/01 7:08:47 AM


When I look at the properties of my SQL installation, the general tab shows the language setting as English (US). How do I make a perm change to British? I have the settings for British in my syslanguages table.

Thanks in advance.

[Asnate]

I had similar problem and I had to rebuild my database - same as reinstalling.

------------
Pete at 10/2/01 2:36:38 AM

Thanks for that, but I've already tried it.
sp_configure now shows the language value as "23"
@@language and @@langid return correctly

BUT

the general tab on the installation properties is incorrect
as is xp_msver

The operating system however shows as correctly as British as well.

Any thoughts? Thanks!


------------
Mohammed. at 10/1/01 1:20:50 PM

sp_configure ....
default language option ...

Mohammed.


------------
Pete at 10/1/01 7:08:47 AM


When I look at the properties of my SQL installation, the general tab shows the language setting as English (US). How do I make a perm change to British? I have the settings for British in my syslanguages table.

Thanks in advance.

[Pete]

Did you do anything different when you reinstalled, Asnate?
Cheers!


------------
Asnate at 10/2/01 4:48:09 AM


I had similar problem and I had to rebuild my database - same as reinstalling.

------------
Pete at 10/2/01 2:36:38 AM

Thanks for that, but I've already tried it.
sp_configure now shows the language value as "23"
@@language and @@langid return correctly

BUT

the general tab on the installation properties is incorrect
as is xp_msver

The operating system however shows as correctly as British as well.

Any thoughts? Thanks!


------------
Mohammed. at 10/1/01 1:20:50 PM

sp_configure ....
default language option ...

Mohammed.


------------
Pete at 10/1/01 7:08:47 AM


When I look at the properties of my SQL installation, the general tab shows the language setting as English (US). How do I make a perm change to British? I have the settings for British in my syslanguages table.

Thanks in advance.

[Asnate]

Yes, US English is the default setting; I can't recall it in a moment but there's somewhere an option while installing where you can choose the language.

------------
Pete at 10/2/01 5:24:23 AM

Did you do anything different when you reinstalled, Asnate?
Cheers!


------------
Asnate at 10/2/01 4:48:09 AM


I had similar problem and I had to rebuild my database - same as reinstalling.

------------
Pete at 10/2/01 2:36:38 AM

Thanks for that, but I've already tried it.
sp_configure now shows the language value as "23"
@@language and @@langid return correctly

BUT

the general tab on the installation properties is incorrect
as is xp_msver

The operating system however shows as correctly as British as well.

Any thoughts? Thanks!


------------
Mohammed. at 10/1/01 1:20:50 PM

sp_configure ....
default language option ...

Mohammed.


------------
Pete at 10/1/01 7:08:47 AM


When I look at the properties of my SQL installation, the general tab shows the language setting as English (US). How do I make a perm change to British? I have the settings for British in my syslanguages table.

Thanks in advance.