Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 fix orphan users

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2009-08-14 : 22:38:40
Hi All,

I have taken a backup from production and restored on a brand new testing machine. How do i fix the users. What are the steps involved in it!

Also, what is difference between
sp_change_users_login Auto_FIX switch and

sp_change_users_login update_one switch.

In which scenarios, shall i use above two????

Seeking for more inputs!!!
   

- Advertisement -