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 |
|
neostar
Starting Member
18 Posts |
 Posted - 2006-01-27 : 06:31:24
|
| How do I change the language from English (United States) to English (United Kingdom) in the server configuration as its currently messing up anything that uses datetimethanksDan |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-01-27 : 09:39:22
|
| BOOKS ONLINEHow to set the default language (Enterprise Manager)To set the default language Expand a server group.Right-click a server, and then click Properties.Click the Server Settings tab.In the Default language for user box, choose the language in which Microsoft® SQL Server™ should display system messages. The default language is English. or T SQLSET LANGUAGE us_englishGO |
 |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-01-27 : 10:37:12
|
| Right click on the server-->Properties-->Server settings and select British English from the dropdown menu |
|
|
|
neostar
Starting Member
18 Posts |
Posted - 2006-01-30 : 02:49:11
|
| I can see the property, but it won't let me change it. By the way this is SQL2005 not 2000thanksDan |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-01-30 : 04:23:17
|
| Oh my mistake. I was referring to 2000 |
|
|
|
|
|
|
Changing the language