sql server - Unable to delete the database user as the user is already logged in currently. error 15434 -


i have created user sagar in sql server 2012 database , mapped xyz database. after time deleted xyz database , don't need existing user sagar also. when try delete user sql srever management studio. getting following exception

could not drop login 'sagar' user logged in. error:15434

user can deleted after killing session identifying session_id of user.

select session_id sys.dm_exec_sessions login_name = 'sagar'  kill 51  --51 session_id here, may different id 

now can delete login executing below query (or) using sql server management studio options.

drop login 'sagar'