Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-19 : 07:21:51
|
| Dominic writes "We have a number of servers which have been installed with the default language set to English (United States).This is causing us no end of problems, as our web sites are throwing out American formatted dates (when we are in the UK).Is there a means by which the default Language of the server can be changed without reinstalling? (The database also serves as the content repository for our Content Management System, and reinstalling it would be a massive undertaking)" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-19 : 12:29:25
|
| Have you checked for the answer in SQL Server Books Online yet? If you go to the index and type in default language, you will find the answer in there.Tara |
 |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-05-19 : 12:48:59
|
| I think a lot of this has to do with the configuration of your web-server, rather than the DB Server. I suggest you check the web-server settings. Also, what technology are you using for the web site - JSP, ASP, PHP? If you are using ASP, you might also want to look into the Session.LCID property, that determines the format of dates and currencies depending on the LocaleID you set it to.OS |
|
|
|
|
|
|
Changing the default system date