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 |
|
soppie
Starting Member
3 Posts |
 Posted - 2011-10-11 : 08:44:59
|
| Hi,I've restored a SQL2005 DB (W2K3 server) to a SQL2008 server (W2K8R2 server)No problems except numbers like 7,5 are stored as 75 in a float field. I see older record values in the float field as 1,5 in the restored DB on SQL2008 server.SQL server and SQL DB settings are the same based on cross reference between servers.Number format settings in windows server also. Only difference is the system locale (dutch on W2K3 and English on W2K8). Is that my problem or can I resolve this in a another way?Thx! |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-10-11 : 08:53:46
|
| Dutch decimal point is , whereas english is . so yes that is probably the problem.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
locale setting