Here are the details of the production environment:
I have completely transfered 100 logins from server
Server A1 contains
5 DATABASES. But I moved only 2 databases from
A2 during the migration of databases from server A1 to Server A2.
I want to drop the users, who are not required on server
A2, because of remaining databases which were not migrated on it.
Please help with any scripts or dmvs to identify which users are not required on server
A2 and thereby dropping them.
If a user has access to multiple databases, how can we remove the login of that user whose concerned database was not migrated from server
Thanks in advance, any valuable suggestions would be helpful for our POC.