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)
 Default Language at Install

Author  Topic 

ubergeek
Starting Member

3 Posts

Posted - 2008-08-27 : 08:12:29
Hi,

Can someone please confirm the following:

On a brand new SQL2K5 install, the Language in the General tab is English (United States) and it can't be changed (at installation time)?

Even if the Default Language in the Advanced tab is changed (to British English in my case), the language displayed in the General tab doesn't change but the Default Language i.e British English would become the system default?

Logins can override the system language default as necessary?

All this is for a client who insists his app isn't working because it says English (United States) in the General tab even though his login has British English as the default

pootle_flump

1064 Posts

Posted - 2008-08-28 : 10:31:17
The setting in the advanced tab is the default language for logins created from that point on. You can also change the language for specific logins (security->Logins->Login->Properties.

What does he say is wrong with his app?
Go to Top of Page

ubergeek
Starting Member

3 Posts

Posted - 2008-08-31 : 18:03:03
Hi, yes that's what I thought! He says any dates updated that have a value>12 in day and/or month are causing his app to crash. I'll find out properly tomorrow when I'm back to work after a holiday!
Go to Top of Page

pootle_flump

1064 Posts

Posted - 2008-09-02 : 07:20:35
You should work with language independent formats:
http://www.karaszi.com/SQLServer/info_datetime.asp

Other relevant article:
http://weblogs.sqlteam.com/jeffs/archive/2008/07/24/60657.aspx
Go to Top of Page
   

- Advertisement -