One of our developers with blanket privilege on a database wanted to create a regular user mapped to a login when what he mistakenly created was a user without login and now I'm unable to remove the user. DROP USER XX command runs forever with no result nor an error. The user doesn't own any schemas as well. How can I remove this user?
Thank you

  • what you are getting the error? Oct 18, 2016 at 7:59
  • "command runs forever with no result nor an error" Oct 18, 2016 at 8:01
  • Do you have "ALTER ANY USER permission on the database of that user". Oct 18, 2016 at 8:05
  • I hope this isn't a production db that a developer has 'blanket' permissions on. Hearing that anywhere makes me choke on my morning coffee.
    – Ian_H
    Oct 18, 2016 at 8:32
  • I'm SA. It's UAT. Oct 18, 2016 at 10:28

1 Answer 1


Check for any blocking SPIDs when you have issued the DROP USER XXX command.

Then kill.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.