Default Language Setting (Server Properties)
-
Hi Guys,
I am auditing some SQL Server 2005 servers.
I have noticed the following.
The windows server is set to British English.
The in the SQL Server Properties the default lanaguage is English (United States).
The default in the Advanced Misc Server settings is English (British) which sets the default for the logins.
Some of these logins are running maintenance plans for back ups etc and are failing because of date issues between these two languages.
I did not install this version of SQL but wanted to know at what point of the installation process did the US language get set up? Is there a step in the installation where you specify which version of English you use. I can't seem to spot it. Or possibly does it take the default of the Windows Server, which at the time of installation may have been US English and someone has since changed this to correct problems they are having. But I'm not sure. I am just investigating.
Next question can you change the default language for SQL Server after it has been installed?
Cheers
Stephen
-
I'm not aware that there is a sql server install of British English, part of the plot to replace s with z and make us all speak as if we were in friends!!!
The general issue around dates is that it relates to the incorrect assignment of the date rather than the actual language, for instance in "english" versions ' 12 jan 2007' is unambiguous as is the 20070112 anything else and you're generally in trouble.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
The problem I have is when setting up maintenance plans they are in us_english but some of the users are set up for British English so when they log in SQL runs the language set is British English and maintenance clean up jobs fail because they are using us date formats
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value"
I have work arounds but wanted to know if it is possible change the server to British English.
My research so far shows apparently you can't
quote form link
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62891𻈟
"I have received a reply from Microsoft that says that SQL Server (when installed on a British English machine) is locked down to US English and there's no way to change it to use UK English. You can change it for individual logins, but I've found this doesn't seem to work all the time. Great..."
There is a hack but I think I will stay away from this.
Cheers
Stephen
-
as I said, a conspiracy to change us to americanised english !! I've always found that keeping to the three date types works well, the other is odbc time. to use across europe you need a more precise form of the month , or the full name, but I don't know ( ok can't be bothered ) to test all the various dates in different languages, I did try french and german and they did work
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
Always enter character date strings in the form '20070113' (or '20070113 23:59:59.997' if you need date and time), and you will not have any problems due to language settings.
-
Thanks Michael,
but the problem I have is the maintenace plan clean up tasks in sql 2005 does not allow you to alter the sql and my server creates the plan with US dates but my users are set to british and the job is executed with the users language and it fails.
Any ideas apart from the obvisous of change the users to us english.
Cheers
Stephen
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply