January 22, 2008 at 12:04 pm
We are facing application issues when the application retrieves database info. The decimal symbol shows up as a comma. This issue occurs randomly. The SQL server is a 2 node cluster (active passive) server. When we resstart the server or failover the SQL services, the issue disappears.
Also, checked the regional settings on the SQL and IIS Servers and both are set to US (English).
What might be causing this issue and what else can we do to fix it?
January 22, 2008 at 1:03 pm
Did you run DBCC CHECKDB?
January 22, 2008 at 1:10 pm
...application retrieves database info...
does your application accept client settings ? Check your client's settings for decimal point. If that is set to comma, it's an application flaw. The application should replace the comma to point when handing the data back to the dataengine or assimilating dynamic sql. !!
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply