Not a lot to comment on this; there is a good discussion here but the key bits to lookup on Books Online are:
The stored proceedure sp_change_users_login, look up the topic Troubleshooting Orphaned Users and the proceedure sp_validatelogins. That should be enough to get it all working when I need to to do it about 2 to 3 years as that seems to be the pattern of these things.
No comments:
Post a Comment