Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Decimal symbol in sql server!!! STILL VERY URGENT!!

Status
Not open for further replies.

VBmim

Programmer
Jun 25, 2001
361
BE
Hello

The situation is as following: (see also thread 'VERY URGENT!! Decimal sign in sql-server)

Moved our sql server from an old nt machine (dutch) to a new windows 2000 machine (english).
Our databases were moved by exporting the data from the old to the new server. It seemed to have been exporting ok...

The new server uses '.' as decimal symbol, as where the old server used ','.

The regional settings on the new server are set to ',' for the decimal sign. All clients who have to connect to our server are nt machines (dutch) with the ',' as decimal sign in regional settings.

I already tried to use 'rebuiltm' on a test database (same environment: w2000 english) and choose for the 'Central European' Character set but it didn't change anything...

Is there anything that can be done?

I'm getting desperate here... This has to be solved by tonight...

Greetz

VBmim
 
I don't have the answer, but for those who are interested in the previous post that VBMim refered to, see THREAD962-635165.

-SQLBill
 
May want to drop the $245 and call Microsoft directly if this is a critical issue that needs to be resolved today.

Paid Support is available by phone at $245 per incident.

Support for Phone Numbers
Small or Home Business (800) 936-4900
Developer (800) 936-5800
IT Professional (800) 936-4900
Partner (resellers or consultants) (888) 456-5570
Original Equipment Manufacturer (800) 936-2197
System Builder (888) 456-5570
Certified Partner (888) 677-9444
TDD/TTY (800) 892-5234


Thanks

J. Kusch
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top