How to drop a SQL Server Login and all its dependencies
https://www.sqlshack.com/drop-sql-server-login-dependencies/
Sometimes, we need to drop a SQL Server Login because we gave an access to a person who left, this login was used by an application that has been decommissioned for example. To do so, we can use SQL Server Management Studio (SSMS) as follows: 1. Open SSMS 2. Connect to a SQL Server instance 3. In Object Explorer, go to « Security » node then logins 4. Right-click on the SQL Server Login you want to drop then click on “Delete” 5. SSMS will show …
Sometimes, we need to drop a SQL Server Login because we gave an access to a person who left, this login was used by an application that has been decommissioned for example. To do so, we can use SQL Server Management Studio (SSMS) as follows: 1. Open SSMS 2. Connect to a SQL Server instance 3. In Object Explorer, go to « Security » node then logins 4. Right-click on the SQL Server Login you want to drop then click on “Delete” 5. SSMS will show …
DA: 26 PA: 84 MOZ Rank: 27