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 |
|
nmg196
Yak Posting Veteran
70 Posts |
 Posted - 2006-02-21 : 12:56:58
|
| Hi,We have installed an application which has caused us to realise that our locale is incorrect on our server by outputting the following error:"Your SQL Server locale setting (us_english/1033) does not match your operating system locale (United Kingdom/2057)."We are UK English speakers but our server reports it is in the US English locale ("us_english/1033"). This doesn't seem to have affected anything else but this particular 3rd party product is insisting the locale matches the locale of the operating system.Is there a way we can change the locale of the server (or maybe just the database) to UK English so it matches the OS locale?There are lots (50) databases on the server and any changes we do must NOT mess up or lose those databases.Thanks,Nick... |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-21 : 13:07:57
|
| I think there are only 2 ways to fix the collation problem. you can rebuild the master database using the rebuildm utility or do a complete uninstall/reinstall of SQL server. You will need to make sure to speciify the proper collation at install time.I think it is possible that the locale of the OS changed after the install of SQL Server becuase the SQL installer usually takes the locale/collation settings from the OS and makes that the default at SQL installation time.Anyway, look up rebuildm utility in BOL for details of how it works. And don't forget to backup all your databases before you make a change like this. You should probably do a test in a non-production environment first just to make sure you have all the bases covered.-ec |
 |
|
|
|
|
|
Can you change locale of server?