January 28, 2011 at 10:02 am
Hello All,
A quick general question, what sis the difference between picking master database or a user database when creating a login?? picking master has any downside???
The reason I am asking this is because if the default database is master when creating a login u can use a ssis task to transfer login during database mirroring
Any insight in this matter is helpful.
January 28, 2011 at 11:09 am
Only real downside of using the "master" as the default is that if the user is not paying attention o what database they are connected to and not using a "use dbname" in their T-SQL, they could inadvertently create objects in the master db, when they mean to be creating them in a different db.
A.J.
DBA with an attitude
January 28, 2011 at 11:21 am
ok , thank you so much for the answer.....
i understand what u mean ..... my issue is if i dont put it in master.... i cant transfer logins with the passwords to the mirroring server.
i know there are scripts and u can run and and run it on the mirror server but i am looking for a automated process and I havent been able to figure or find one for that effect.
thanks for the answer again .
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply