crazy4sql (12/5/2011)
Script is good if we have all the required logins in place else we still need to create the logins first.Also sp_change_users_login, report only about the orphaned sql login not the windows login.
Yes- we are not creating logins. This is a cross envrionment database restore- if there are server scope objects required, then those need to be scripted out seprately.
As for windows users- not sure what you are referring to. Windows users have the same SID and therefore do not become orphaned.