Skip to main content
Database Administrators

Return to Question

spelling check, formatting
Source Link
Kin Shah
Kin Shah
  • 62.4k
  • 6
  • 122
  • 240

Here are the details of the production environment:

I have 2 serevrs2 serevrs, A1A1 and A2A2.

I have completely transfertransfered 100 users logins from server A1A1 to A2A2.

Server A1Server A1 contains 5 DATABASES5 DATABASES. But I moved only 2 databases from A1A1 to A2A2 during the migration of databases from server A1 to Server A2.

I want to drop the users, who are not required on server A2A2, 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 A2A2 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 A1A1 to A2A2.

Thanks in advance, any valuable suggestions would be helpful for our POC.

Thanks very much again.

Here are the details of the production environment:

I have 2 serevrs, A1 and A2.

I have completely transfer 100 users logins from server A1 to A2.

Server A1 contains 5 DATABASES. But I moved only 2 databases from A1 to 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 A1 to A2.

Thanks in advance, any valuable suggestions would be helpful for our POC.

Thanks very much again.

Here are the details of the production environment:

I have 2 serevrs, A1 and A2.

I have completely transfered 100 logins from server A1 to A2.

Server A1 contains 5 DATABASES. But I moved only 2 databases from A1 to 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 A1 to A2.

Thanks in advance, any valuable suggestions would be helpful for our POC.

spelling check, formatting
Source Link
edit approved Apr 24, 2015 at 17:28
KASQLDBA
edit approved Apr 24, 2015 at 17:28
KASQLDBA
  • 7.2k
  • 6
  • 30
  • 53

Greetings! Here isHere are the details of the production environment like:

I have 2 serevrs, A1 and A2. 

I have completely transfer 100 users log inslogins from server A1 to A2 Which have.

Server A1(5 contains 5 DATABASES). But I moved only 2 databases from A1 to A2 Due toduring the migration time linesof databases from server A1 to Server A2.

I want to drop the users, who are not required on server A2, because of remaining databases arewhich were not exist in the server A2migrated on it.

pleasePlease help whichwith any scripts or dmvs help to identify first which users are not rquired inrequired on server A2 and thereby dropping them. 

If a user havehas access to multiple databases, how can we remove the login to the user which hisof that user whose concerned database was not migrated tofrom server A1 to A2.

Thanks in advance, any valuable suggestions would be helpful for our POC.

Thanks very much again.

Greetings! Here is the production environment like:

I have 2 serevrs, A1 and A2. I have completely transfer 100 users log ins from server A1 to A2 Which have A1(5 DATABASES). But I moved only 2 databases from A1 to A2 Due to migration time lines.

I want to drop the users, who are not required, because of databases are not exist in the server A2.

please help which scripts or dmvs help to identify first which users are not rquired in A2 and dropping them. If a user have access to multiple databases, how can we remove the login to the user which his database was not migrated to server A1 to A2.

Thanks in advance, any valuable suggestions would be helpful for our POC.

Thanks very much again.

Here are the details of the production environment:

I have 2 serevrs, A1 and A2. 

I have completely transfer 100 users logins from server A1 to A2.

Server A1 contains 5 DATABASES. But I moved only 2 databases from A1 to 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 A1 to A2.

Thanks in advance, any valuable suggestions would be helpful for our POC.

Thanks very much again.

Source Link
Jayaram Peri
Jayaram Peri
  • 11
  • 1

removing sql logins from one server, after migrating to another server, but all the databases were not migra

Greetings! Here is the production environment like:

I have 2 serevrs, A1 and A2. I have completely transfer 100 users log ins from server A1 to A2 Which have A1(5 DATABASES). But I moved only 2 databases from A1 to A2 Due to migration time lines.

I want to drop the users, who are not required, because of databases are not exist in the server A2.

please help which scripts or dmvs help to identify first which users are not rquired in A2 and dropping them. If a user have access to multiple databases, how can we remove the login to the user which his database was not migrated to server A1 to A2.

Thanks in advance, any valuable suggestions would be helpful for our POC.

Thanks very much again.