Hi,
I've been restoring databases from another domain. As a result the users that are restored with the db have the user accounts from the other domain, and are not linked to a login.
So I've been going in to each db I restore and looking at the permissions, and then adding a login with the matching permissions to that db with the correct domain account. The names for the most part are the same just with a different domain prefix.
This is taking forever, because I'm also removing the old domain db users, and I have to change schema owners in some cases to delete the user.
Has anyone found a faster way to do this, even just a little bit faster? If you can help thanks....