Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

effect of regional settings on isql output Expand / Collapse
Posted Friday, November 14, 2008 3:13 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:33 AM
Points: 710, Visits: 401

we have a 3-node cluster with some SQL instances running on them.
Regional settings on all nodes are the same. When I execute a select statement via isql.exe on the nodes I get different date format in the result set. Two nodes (the ones on which the SQL instance is not running) show me dates like "Sep 2 2008", the other node (on which the SQL instance is running) shows "2 sep 2008".

I don't know why... but maybe someone out there does?

Post #602599
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse