gordy
asked on
Adding an alternate language/region
How do I change the date formats in SQL Server from US to UK english? I have tried adding UK English as a language from the SQL Setup, but it keeps asking for a file COMMON.LOC. I'm not sure where this is found. (Some sort of regional pack maybe?) When I get this working I also want to experiment by adding other alternate languages.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
File COMMON.LOC you can create from sqlcomm,loc located in i386 directory of you SQl server distribution media.
Try running the instlang.sql script that comes on the SQL Server Installation CD.
This Script installs lots of different languages, including English (British).
Then all you have to do is use a system stored procedure called sp_defaultlanguage, or something like that anyway. This SP sets the default language for a particular user. Use it like so:
sp_defaultlanguage sa,british
this sets the default language for sa to british.
Cheers, hope this helps.
This Script installs lots of different languages, including English (British).
Then all you have to do is use a system stored procedure called sp_defaultlanguage, or something like that anyway. This SP sets the default language for a particular user. Use it like so:
sp_defaultlanguage sa,british
this sets the default language for sa to british.
Cheers, hope this helps.
ASKER
Thanks for your reply. This certainly gave me a good starting point, and from there I've been able to progress further. Thanks