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?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.