Multiple group default database

SQL Server 2000. Windows Auth. If a Windows login is a member of multiple
local groups on the SQL Server box, and each local group maps to a SQL Serve
r
login, and the logins have different default databases, how do you determine
what default database is used for a given Windows login?
Thanks
VernVern,
There is an order. When I tested it seemed like alphabetical order, but I
did not absolutely verify it. Try assigning the first alphabetical group
for a user to default to a database where he has no rights and see if this
causes a login failure.
RLF
"Vern Rabe" <VernRabe@.discussions.microsoft.com> wrote in message
news:7C825239-6888-4DEC-BE0B-59CFB3D2764A@.microsoft.com...
> SQL Server 2000. Windows Auth. If a Windows login is a member of multiple
> local groups on the SQL Server box, and each local group maps to a SQL
> Server
> login, and the logins have different default databases, how do you
> determine
> what default database is used for a given Windows login?
> Thanks
> Vernsql