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.
gordyAsked:
Who is Participating?
 
vvkConnect With a Mentor Commented:
You can add any language by executing
insert into syslanguages values(langid, dateformat, datefirst, upgrade, name, alias, months, shortmonths, days)
langid - any unused (default use 0 all other you can find in select * from syslanguages)
dateformat - dmy|mdy|ydm etc.
datefirst - first day of week
upgrade - 0
name - desired name of language
alias -
months - long names of month separated by comma
shortmonths - short names separated as above
days - names of week days separated as above

Also you can set desired data format by function convert in any select statement
0
 
vvkCommented:
File COMMON.LOC you can create from sqlcomm,loc located in i386 directory of you SQl server distribution media.
0
 
KirkGrayCommented:
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.

0
 
gordyAuthor Commented:
Thanks for your reply. This certainly gave me a good starting point, and from there I've been able to progress further. Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.