Showing posts with label leaving. Show all posts
Showing posts with label leaving. Show all posts

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
BrianOne downside changing it is that most tools doesn't allow you to login if yo
u 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.googlegroups.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.googlegroups.com...
> Is there any concern in leaving master as a user's default database or
> should it be changed to another db?
> Thanks
> Brian
>sql

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
BrianOne 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.googlegroups.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.googlegroups.com...
> Is there any concern in leaving master as a user's default database or
> should it be changed to another db?
> Thanks
> Brian
>

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
>