SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Default Language at Install
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ubergeek
Starting Member

United Kingdom
3 Posts

Posted - 08/27/2008 :  08:12:29  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
1064 Posts

Posted - 08/28/2008 :  10:31:17  Show Profile  Reply with Quote
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

United Kingdom
3 Posts

Posted - 08/31/2008 :  18:03:03  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
1064 Posts

Posted - 09/02/2008 :  07:20:35  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000