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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server 2012: Regional Setting

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-07-17 : 13:49:01
Ah, I think you mean VM (virtual machine), or at least that's what it's called in the U.S.

This might help you: http://stackoverflow.com/questions/1229147/sql-server-with-german-regional-settings

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jcarrallo
Starting Member

35 Posts

Posted - 2014-07-19 : 11:45:06
Thanks Tara
Go to Top of Page
   

- Advertisement -