Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by xyn64
-
NT Groups resulting in multiple Default databases
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?- xyn64
- Post #3
- Forum: Microsoft SQL Server: Programming
-
NT Groups resulting in multiple Default databases
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...- xyn64
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
