Drop orphaned users from SQL server databases

A database user is referred to as the orphaned user if the user's SQL Server login is undefined or the login is incorrectly defined on a server instance. Such orphaned users must be removed.

Run this T-SQL query to remove an orphan user:

DROP USER <username>;