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)
 Determining default database

Author  Topic 

gam
Starting Member

9 Posts

Posted - 2005-09-22 : 08:44:05
I have a domain account(A1) that is in 2 domain groups(G1 and G2). Each of these groups(not the domain account) has login permission and each group has a different default database - G1 to DB1 and G2 to DB2. When A1 connects to the server without specifying a database, which database is A1 connected to?

Also if one of the databases is made unavailable(dbo only) does this prevent access to the other database?

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-09-22 : 09:22:55
sp_helpuser ?

====================================================
Regards,
Sean Roussy

aka the merciless black hearted capitalist troublemaker

"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?)
Go to Top of Page
   

- Advertisement -