hi all,

I'm facing a critical problem with SQL Server.

I'm saving a data in to numeric field as 1,000. It saved correctly but when I retrieving it, will become 1. If it is 10,000 return as 10.

My server is windows server 2003. When I'm doing the same process, it's retrieved correctly. I'm facing this problem only in windows server 2003. I'm using sql server 2000.

Can any one tell me what could have happened?

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

Perhaps the regional options on the server have comma specified as the
decimal separator and the tool you are using honors that setting.

Do you have the same problem if you execute an INSERT from Query Analyzer on the server?

Hi there,

Have you check reginal settings?

Yes, I checked the regional settings. Everything is ok. The settings
are the same as Windows XP.

My server has Windows Server 2003. When I insert, the value is updated correctly in SQL Server. The problem only happen when I retrieve. And I realized this problem only happen recently, after many updates from Microsoft to
update my servers.

Has anybody encountered this?

Thanks!

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

So you using Query Analyzer to retrieve the data and get the different
results from XP vs. Windows Server 2003? Does the following return the same
results?

SELECT 1,000

--
Hope this helps.