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 - 2004-05-13 : 08:10:40
|
| natalia writes "Hi,I have SQL server 2000 which runs on the server with US regional settings.(including dataformat "mm/dd/yyyy")I need to change settings for UK..(including dataformat "dd mmm yyyy")How it will affect Sql server?Thanks." |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-05-13 : 10:51:07
|
| O/S level date format changes will not affect SQL server.------------------------I think, therefore I am |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-13 : 13:14:27
|
| Dates aren't stored in US format anyway in SQL Server. You get dates OUT of SQL Server in a particular format with CONVERT and a style if you don't like the default.Tara |
|
|
|
prateek
Starting Member
1 Post |
Posted - 2004-06-11 : 07:44:26
|
| Just open your Enterprise Manager and go to Security/Login. In that see the properties of the user login with which you connect to your database and set the default language to British English. Your Problem would be solved.Thanks and RegardsPrateek Gandhigandhiprateek@hotmail.com |
|
|
|
|
|
|
Change Regional Settings