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.
| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2003-05-22 : 06:31:34
|
| Hello ,I was referring to the script library to look at the script called " fix orphaned users " which transfers logins from one server to another and in case of a database restore . Further to test it , I have executed in the master DB on a test env. which has created a stored procedure called sp_fixusers . Would like to know on which server this script has to be executed . I am transferring all the logins from Prod. to DR site . Do i have to execute a transfer login DTS task first and then execute this script ? Do the logins have to be in the DR server already so that they will be mapped to their respective DB's when this script is executed . Need clarifications on this please .Thank you very much . |
|
|
|
|
|
Transfer Login script .