Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Server Language

Author  Topic 

dewacorp.alliances

452 Posts

Posted - 2008-02-13 : 19:53:52
Just curiosity ... never pick up this since beginning. Our box is setted the language to English (United States) while the local machine setted as English (Australia) which I thought it's corresponding to locale machine not sql box.

Will this language setting effecting date issue stuff (DD-MM-YYYY)? Can someone clarify on this?

This thing brought up my attention cause we've just ran a trace and there is a warning which is:

User Error Message - Changed language setting to us_english.

Thank you.






rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-16 : 00:13:16
You can change it with 'set dateformat'
Go to Top of Page
   

- Advertisement -