NT Groups resulting in multiple Default databases 1

[xyn64]

Does anyone know what method of resolution NT/ADO/SQL Server use to decide what the default database is for a user who belongs to multiple roles on a SQL Server.

Got a situation here which leads to 3 possible default databases.

In addition, why is the default db used when a database has been specified in the connection?!?

Thanks,

John

 

[Cagliostro]

The default database doesnt exists if is specified. If not, then usualy it is master. You can see it in EnterpriseManager->Security->Logins look in the properties->General. John Fill

ivfmd@mail.md

 

[xyn64]

Thanks John, but not quite what I was after.

Perhaps an example might help.

If role A has default database Apples, and role B has default database Oranges, and I have a user who belongs to role A and B what is their default database?

 

[Cagliostro]

The default database make sence when you're connecting to some server or some driver. When you are connecting to a database or to a server on specifying database name, the defacult database is database you're connected. John Fill

ivfmd@mail.md