Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 default database determination

Author  Topic 

gam
Starting Member

9 Posts

Posted - 2005-01-27 : 08:50:37
I have a user(u1) who is in 2 domain groups(grp1 and grp2). Each group has login permission and has access to a separate database(db1 and db2). The default database for grp1 is db1 and for grp2 it's db2. When u1 connects to the server without specifying a database, how does SQl server determine which database to use as the default.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-01-27 : 16:15:46
Probably whichever group information it finds first.

Tara
Go to Top of Page
   

- Advertisement -