Friday, March 30, 2012

pros/cons keeping master as default db

Is there any concern in leaving master as a user's default database or
should it be changed to another db?
Thanks
Brian
One downside changing it is that most tools doesn't allow you to login if you remove your default
database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Brian D" <bdaltilio@.yahoo.com> wrote in message
news:1179339438.486854.196200@.q23g2000hsg.googlegr oups.com...
> Is there any concern in leaving master as a user's default database or
> should it be changed to another db?
> Thanks
> Brian
>
|||Brian,
My take is that master is a safe default for everybody who does not have
rights to modify master. For those of us who _can_ modify master, please be
careful.
RLF
"Brian D" <bdaltilio@.yahoo.com> wrote in message
news:1179339438.486854.196200@.q23g2000hsg.googlegr oups.com...
> Is there any concern in leaving master as a user's default database or
> should it be changed to another db?
> Thanks
> Brian
>

No comments:

Post a Comment