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 |
|
disarm
Starting Member
2 Posts |
 Posted - 2010-01-26 : 09:39:32
|
| HiWe have an AspDotNetStorefront database in US-locale which we need to change to GB-locale from US-locale. This is due to a Arithmetic overflow error. I have been in to properties/options/Collation but I don't know which one from the drop-down list refers to GB-locale. Google brings up lots of results that I don't really understand (I'm not an SQL-developer). Any ideas?Thanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-26 : 10:03:46
|
| can we see the offending code? seems unlikely the overflow is a collation issue...Anyway, it'sALTER DATABASE yourDbCOLLATE collationNameRead this 1st: http://msdn.microsoft.com/en-us/library/ms174269.aspx |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-26 : 10:16:06
|
| We don't rely on anything to do with the Server's Locale, its just too risky when things get moved around.COLLATION is a different matter - you have to choose, and live with!, one of those.But as Russell says this is unlikely to effect Arithmetic overflow in SQL.I think its more likely that your ASP.NET application is relying on the Locale of the machine it is running on - you probably change that using Control Panel : Regional Settings on the machine ASP.NET is running on. |
|
|
|
disarm
Starting Member
2 Posts |
Posted - 2010-01-26 : 10:23:10
|
| Thanks for all of your replies. |
|
|
|
|
|
|
Correct SQL locale for GB