How do I remove a user from a SQL Server database?

To remove a user from a SQL Server database, you can use SQL Server Management Studio (SSMS) or execute a T-SQL command. I will explain both methods in detail.

Method 1: Using SQL Server Management Studio (SSMS)
1. Open SSMS and connect to the SQL Server instance that hosts the database containing the user you want to remove.
2. In Object Explorer, navigate to the “Security” node, expand it, and click on “Logins”. This will display a list of all the logins registered on the SQL Server instance.
3. Find the login representing the user you want to remove and right-click on it.
4. From the context menu, select “Delete”. SSMS will display a warning message asking for confirmation.
5. Read the warning message carefully, as removing a login can have significant consequences, such as revoking access to the associated databases and objects. Make sure you understand the implications before proceeding.
6. Click “OK” to confirm the deletion. The login representing the user will be removed from the SQL Server instance, and their access to the associated databases will be revoked.

Method 2: Using T-SQL Command
1. Open SSMS and connect to the SQL Server instance.
2. Open a new query window and execute the following T-SQL command, replacing `` with the name of the user you want to remove:

“`sql
USE [database_name];
DROP USER ;
“`

Note: Replace `[database_name]` with the actual name of the database where the user exists.