SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server 2012: Regional Setting
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jcarrallo
Starting Member

Spain
29 Posts

Posted - 07/17/2014 :  10:05:44  Show Profile  Reply with Quote
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

USA
36997 Posts

Posted - 07/17/2014 :  13:09:20  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

Spain
29 Posts

Posted - 07/17/2014 :  13:23:15  Show Profile  Reply with Quote
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

USA
36997 Posts

Posted - 07/17/2014 :  13:49:01  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

Spain
29 Posts

Posted - 07/19/2014 :  11:45:06  Show Profile  Reply with Quote
Thanks Tara
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000