Could not drop login 'loginname' as the user is currently logged in.
I go the below error in one our environments.
Below are the troubleshooting steps. Run the below command find the session id that are using by that particular session KILL all the session KILL
SELECT session_id FROM sys.dm_exec_sessions WHERE login_name = 'LoginName'
USE [master] GO DROP LOGIN [LoginName]
Comments