|
|
|
date: Tue, 26 Aug 2008 05:34:31 -0700 (PDT),
group: microsoft.public.sqlserver.security
back
Windows User, Multiple group memberships, different default languages
Hi all,
I'm trying to fathom out whether the default language of a user is
well defined, and if so what the definition would be:
DOMAIN\User is a member of DOMAIN\Group1 and DOMAIN\Group2.
DOMAIN\Group1 and DOMAIN\Group2 are logins on the SQL Server. DOMAIN
\User is not.
DOMAIN\Group1's default language is English
DOMAIN\Group2's default language is British English
My question is, when DOMAIN\User logs on, is their default language
well defined?
Obviously, I could connect as the user and see what default they get,
but there could be some combination of time of day/server load/phase
of moon/service pack which always sets it one way for every trial I
make, but sets it the other way at other times.
Thanks for any advice,
Damien
date: Tue, 26 Aug 2008 05:34:31 -0700 (PDT)
author: Damien
Re: Windows User, Multiple group memberships, different default languages
Damien (Damien_The_Unbeliever@hotmail.com) writes:
> I'm trying to fathom out whether the default language of a user is
> well defined, and if so what the definition would be:
>
> DOMAIN\User is a member of DOMAIN\Group1 and DOMAIN\Group2.
> DOMAIN\Group1 and DOMAIN\Group2 are logins on the SQL Server. DOMAIN
> \User is not.
> DOMAIN\Group1's default language is English
> DOMAIN\Group2's default language is British English
>
> My question is, when DOMAIN\User logs on, is their default language
> well defined?
>
> Obviously, I could connect as the user and see what default they get,
> but there could be some combination of time of day/server load/phase
> of moon/service pack which always sets it one way for every trial I
> make, but sets it the other way at other times.
I don't know the answer to the question, but I'll bring it up in our
internal MVP forum, as the question is interesting.
My own gut-feeling answer is that you should write your code so that
it does not matter. The prime difference between US English and British
English is the date format. Use a date format that is insensitive to
date-format setting, for instance YYYYMMDD.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
date: Sat, 30 Aug 2008 04:09:02 -0700
author: Erland Sommarskog
Re: Windows User, Multiple group memberships, different default
languages
On Aug 30, 12:09 pm, Erland Sommarskog wrote:
> Damien (Damien_The_Unbelie...@hotmail.com) writes:
> > I'm trying to fathom out whether the default language of a user is
> > well defined, and if so what the definition would be:
>
> > DOMAIN\User is a member of DOMAIN\Group1 and DOMAIN\Group2.
> > DOMAIN\Group1 and DOMAIN\Group2 are logins on the SQL Server. DOMAIN
> > \User is not.
> > DOMAIN\Group1's default language is English
> > DOMAIN\Group2's default language is British English
>
> > My question is, when DOMAIN\User logs on, is their default language
> > well defined?
>
> > Obviously, I could connect as the user and see what default they get,
> > but there could be some combination of time of day/server load/phase
> > of moon/service pack which always sets it one way for every trial I
> > make, but sets it the other way at other times.
>
> I don't know the answer to the question, but I'll bring it up in our
> internal MVP forum, as the question is interesting.
>
> My own gut-feeling answer is that you should write your code so that
> it does not matter. The prime difference between US English and British
> English is the date format. Use a date format that is insensitive to
> date-format setting, for instance YYYYMMDD.
>
Hi Erland,
Thanks for taking an interest. I do try to write insensitive code
anyway. It's more a matter of interest for me than anything else -
we're a British company, but for a long time our servers were set up
with us english defaults. We're now talking about moving an
application from one of the older (us english everywhere) servers to a
newer (british english generally) server. I was wondering whether to
set up the login groups from the old server as us english, and then
started wondering what would happen if two groups coincided on the
server.
It's not an urgent one, and I can live with "undefined". I just
couldn't find anything written about it.
Damien
date: Mon, 1 Sep 2008 00:42:03 -0700 (PDT)
author: Damien
|
|
