|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Overcoming orphans
How do you restore master to a new database and not orphan users in the
process? Look up sp_change_users_login in BOL.
-- Geoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP "Robert R via SQLMonster.com" <u3288@uwe> wrote in message news:5d589125f94ca@uwe...Show quoteHide quote > How do you restore master to a new database and not orphan users in the > process? > > -- > Message posted via http://www.sqlmonster.com  
Other interesting topics
Move DB by backup/restore or SP_Detach?
Deadlocks "again" How to "Grant" a Trigger ??? IN clause with comma seperated values in select query Table comparison what kind of index to use in this situation. Add User to Log-Shipped Database sqlserver 2005 express license Licensing by the month? MSDE 2000 problems with linked server |
|||||||||||||||||||||||
