How do you restore master to a new database and not orphan users in the
process?
Message posted via http://www.droptable.com
Look up sp_change_users_login in BOL.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert R via droptable.com" <u3288@.uwe> wrote in message
news:5d589125f94ca@.uwe...
> How do you restore master to a new database and not orphan users in the
> process?
> --
> Message posted via http://www.droptable.com
Showing posts with label theprocessmessage. Show all posts
Showing posts with label theprocessmessage. Show all posts
Monday, February 20, 2012
Overcoming orphans
How do you restore master to a new database and not orphan users in the
process?
Message posted via http://www.droptable.comLook up sp_change_users_login in BOL.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert R via droptable.com" <u3288@.uwe> wrote in message
news:5d589125f94ca@.uwe...
> How do you restore master to a new database and not orphan users in the
> process?
> --
> Message posted via http://www.droptable.com
process?
Message posted via http://www.droptable.comLook up sp_change_users_login in BOL.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert R via droptable.com" <u3288@.uwe> wrote in message
news:5d589125f94ca@.uwe...
> How do you restore master to a new database and not orphan users in the
> process?
> --
> Message posted via http://www.droptable.com
Subscribe to:
Posts (Atom)