Post reply

SQL Query returning different results on different cluster nodes

  • July 17, 2012 at 2:11 pm

    #278037

    We are facing an issue on a SQL 2005 cluster server. The following query Select * from openquery(------,'.......) used in an SSIS package is returning different results when the SQL services are running on different nodes of the cluster. On one node it returns results with a decimal point as it should, while on the other node it returns the same value with commas.

    What could be causing this difference ?

    TIA

  • July 17, 2012 at 2:13 pm

    #1513877

    Sounds like two different language settings on the servers (OS).

  • July 17, 2012 at 2:19 pm

    #1513881

    Thanks. yes we already checked that from the Regional and Language settings in the control panel and it is exactly the same on both nodes. Should we check any other place?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply