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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-23 : 08:02:01
|
| Mike writes "Is there any known reason that the default database should not be set to MASTER. For example: There are 25 databases on a particular server and instead of having the default database be set to the application user database you want to set it to MASTER to eliminate problems. Some problems are when you put a database in DBO USE ONLY and the default database is is the database you put in DBO USE ONLY and the user exist in more than one database. If the default was set to MASTER then the user would not be impacted on the other database(s) they need to access.ThanksMike" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2003-09-23 : 09:58:53
|
| If you have a lot of users that connect with ad-hoc query tools, and you set their default database to master, I can guarantee you'll get several panicked calls every week: "Help!!! My table is gone!!! I've lost all my data!!!". And every time you'll have to explain to those people that the data is right where it is supposed to be -- in another database. However, if all user access is through a gui-based app, you can leave default database as master. |
 |
|
|
|
|
|
Syslogins and default database