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 |
jcarrallo
Starting Member
35 Posts |
Posted - 2014-07-17 : 10:05:44
|
Hello,Can I change the regional settings of sql server 2012?Let me explain:I have two VPS with SQL server 2012 installed in each of them.My problem is with the decimals: when running a select in SQL server 2012, the same table definition looks different depending on the server:For example, A numeric field would look like:Server#1: 21,9028 (with a comma)Server#2: 21.9028 (with a dot)And this is causing me problems. Can anyone tell me how to change this?Many thanks in advanced!!!Jay |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-17 : 13:09:20
|
Isn't that set at the OS level and not at the SQL level? I believe it's done somewhere in Control Panel. Check the regional settings on both servers in Control Panel.By the way, what is "VPS"?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
jcarrallo
Starting Member
35 Posts |
Posted - 2014-07-17 : 13:23:15
|
Thanks.Yes, in the control pannel you can change that.The problem is that I installed SQL 1 server with US settings (uses decipa and 1 with French setting (uses ,)And now, by default SQL is reading those different setting. I might have to uninstall SQL and install it again using the correct setting.VPS - I understand that stands for virtual private server. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
jcarrallo
Starting Member
35 Posts |
Posted - 2014-07-19 : 11:45:06
|
Thanks Tara |
|
|
|
|
|